|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
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" Thanks
|
|
#2
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.
|
|
#3
October 1st, 2002, 02:15 PM
|
|||
|
|||
|
Of course, spell checking should take place first. LOL
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > User friendly errors |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
