#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Posts
    6
    Rep Power
    0

    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
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Location
    Columbus, OH
    Posts
    14
    Rep Power
    0
    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.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Location
    Columbus, OH
    Posts
    14
    Rep Power
    0
    Of course, spell checking should take place first. LOL

IMN logo majestic logo threadwatch logo seochat tools logo