Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HenryFulmer
Posting Yak Master
110 Posts |
 Posted - 2012-09-13 : 15:09:33
|
| Is it possible to grant permission to a specific stored procedure for a user?We are short on SQL developers right now and I was hoping I can give access to modifiying only certain sp to less experienced developers without giving overall administrative access.Any advice is appreciated. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-13 : 15:18:32
|
I think you should be able to do that using:GRANT ALTER ON dbo.StoredProcNameHere TO UsernameHere |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-13 : 16:49:35
|
| the statement above is correct . For ease of managing permissions - create a Role - which has relevant privileges - and then attach role to userJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
HenryFulmer
Posting Yak Master
110 Posts |
Posted - 2012-09-19 : 13:43:25
|
| Thank you. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-09-20 : 01:40:03
|
| your welcomeJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Grant Permissions on a Stored Procedure