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 |
|
ericgeil
Starting Member
1 Post |
 Posted - 2011-02-28 : 11:53:18
|
| I am getting an unexpected error in SQL 2000, granting EXEC permission for a SP. I am logged in with Windows login which has "sa" permissions. I created the SP, then issued the following:GRANT EXEC ON spWhatever to SomeRolethe command executes with no error. When I double click the SP in Enterprise Mgr and view the permissions, the permission shows up as expected. When I try to execute the SP as a member of SomeRole, I get the error messageGrantor does not have GRANT permission.BUT- I also see the data. It returns the data AND the error!I've granted permissions to literally thousands of SPs using this same account, and this same "GRANT" statement. I created the SP using the same account. What is going on here? Thanks in advance. Eric |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-02-28 : 23:05:44
|
| GRANT EXEC ON spWhatever to SomeRoleIn the above statement you should have used "WITH GRANT OPTION ".Something like:GRANT EXEC ON spWhatever to SomeRole WITH GRANT OPTION Read more at:http://msdn.microsoft.com/en-us/library/ms186717(v=sql.90).aspx |
 |
|
|
|
|
|
Grantor does not have GRANT permission.