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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-05-22 : 15:48:16
|
| Hi,This is a sumple question, Please help I am trying to figure out how to give a user alter stored procedure permission,one user has exec permission,but they want permission to alter it. I know how to do it in sql server 2005 but not in 2000. Please helpThanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-05-22 : 20:51:03
|
| for 2000 (and I believe 2005) to alter a procedure the user needs to be one of the following:sysadmin - fixed server roleddladmin - db roledbo -db roleBe One with the OptimizerTG |
 |
|
|
|
|
|
Grant alter permission to a stored procedure