|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Laplink Gold 2008 - $15 Off with Coupon Code CJM9NE
|
|
#1
September 30th, 2003, 02:07 PM
|
|||
|
|||
|
Want to know about SQL user permission
Hi ,
One on my SQL users wants to execute few sql system stored procedure and wanna execute Bulk insert on the database server .. SO what permission should be assigned to the users to that he can do his desigred above task. Thanks
|
|
#2
October 5th, 2003, 07:34 AM
|
|||
|
|||
|
See thread : "User rights" posted by "buggirls" on October the 5th. if that satisfy yours expectations.
Once the user have been authetificated, it has the right to handle the database. Best regards ciao. Juanelo Von Seattle
|
|
#3
October 5th, 2003, 12:06 PM
|
||||
|
||||
|
I posted a better explanation (IMHO of course) in the same thread: http://forums.devshed.com/t85952/s.html
The first para covers how to set up Bulk Insert rights. Well, it actually covers Database Creation rights, but Bulk Insert is one of the other items in the same screen, so you should have no trouble setting it up. The second and third paras cover how to set up rights for selected stored procedures and tables. Hope this helps 
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home. "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest Down with Sharon Osbourne Puzzle of the Month solved by sizeablegrin, etienne141 and L7Sqr, superior C/C++ programmers of the month
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Want to know about SQL user permission |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
