October 1st, 2002, 06:34 AM
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"
October 1st, 2002, 02:14 PM
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.
October 1st, 2002, 02:15 PM
Of course, spell checking should take place first. LOL