Getting around ''Grantor does not have GRANT permission''
-
I'm new to Sql Server and need some pointers on users & grants,
I'm trying to do
grant execute on <stored_procedure_name> to public
where the user I'm logged in as is not the owner/creator of the store procedure.
And I get 'Grantor does not have GRANT permission'
What do I need to do to make this work?
-
The login (user) you are logged in has needs to have grant permission on the stored procedure for you to be able to grant permissions to others. You either need to have a SQL DBA grant you that permission, or login with a user that already has that permission.
-
Sorry not to be clear here, Its not a conceptual question, its a command syntax question.
Say I'm logged in as a user that has the permission to grant myuser whatever he wants, is there a special syntax that will let myuser then pass on this grant or is that by simply having the permission you can bestow it upon other users. In Oracle you have to use 'with grant option' so I wondered if there is something like that for SqlServer or is just that if I have it I can give it?
- John
-
Just add WITH GRANT OPTION to the end of your grant statement, just like Oracle.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply