 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / March 2008Stored Proc security
How do I grant execute proc privileges in SQL Server 2005?  SignatureArne Garvander Certified Geek Professional Data Dude Take a look at the GRANT statement in BooksOnLine and use the EXEC option. SignatureAndrew J. Kelly SQL MVP Solid Quality Mentors > How do I grant execute proc privileges in SQL Server 2005? I give you half a lemon for that answer. SignatureArne Garvander Certified Geek Professional Data Dude > Take a look at the GRANT statement in BooksOnLine and use the EXEC option. > > > How do I grant execute proc privileges in SQL Server 2005? I give you half a lemon for that question:). A simple search in either BooksOnLine or Google would have yielded the answer. Now that may sound rude but most answers posted here can be solved faster and easier for all involved by doing these simple searches. This was an attempt to get you (and others) in the habit of utilizing BOL as it is a wonderful tool that has most answers like this. In the long run it will save you lots of time. SignatureAndrew J. Kelly SQL MVP Solid Quality Mentors >I give you half a lemon for that answer. > >> Take a look at the GRANT statement in BooksOnLine and use the EXEC >> option. >> >> > How do I grant execute proc privileges in SQL Server 2005? Thanks for the lemon. I will try to read books online next time. I did try Google before posting my question. SignatureArne Garvander Certified Geek Professional Data Dude > I give you half a lemon for that question:). A simple search in either > BooksOnLine or Google would have yielded the answer. Now that may sound rude [quoted text clipped - 9 lines] > >> > >> > How do I grant execute proc privileges in SQL Server 2005? No it was only half a lemon:). At least you are taking the correct approach and granting individual rights instead of making the user sa. SignatureAndrew J. Kelly SQL MVP Solid Quality Mentors > Thanks for the lemon. > I will try to read books online next time. I did try Google before posting [quoted text clipped - 15 lines] >> >> >> >> > How do I grant execute proc privileges in SQL Server 2005? > How do I grant execute proc privileges in SQL Server 2005? GRANT EXEC ON some_sp TO nisse -- Grant permission on a single procedure. GRANT EXEC ON SCHEMA::dbo TO kalle -- Grant perpmission on all procedures in the dbo schema GRANT EXEC TO putte -- Grant EXEC permission all procedures in the database. SignatureErland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx I wish I could visit one of those beautiful Swedish summer forests ,with blueberries and birds signing. SignatureArne Garvander Certified Geek Professional Data Dude > > How do I grant execute proc privileges in SQL Server 2005? > > GRANT EXEC ON some_sp TO nisse -- Grant permission on a single procedure. > GRANT EXEC ON SCHEMA::dbo TO kalle -- Grant perpmission on all procedures in > the dbo schema > GRANT EXEC TO putte -- Grant EXEC permission all procedures in the database. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.