September 30th, 2003, 02:07 PM
Want to know about SQL user permission
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.
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.
ciao. Juanelo Von Seattle
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
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo