User friendly errors

Ultimately i figured out the way how to manage Logins and roles in SQl 2000.

My next problem is that is their some way where in i can show the client (who has got only db_datareader permissions) user friendly errors , if he tries to insert something into table.

or in other words can i show user friendly errors like "U are not allowed to insert into dateabse" , or may be "Contact your local administrator for assigning rights to insert into database"


Thanks

I'd probably handle it through a trigger. When anyone tries to do an insert, check their login and try to capture the error first, then you could print a nicer message.

Of course, spell checking should take place first. LOL