sql-serverssmsssms-2012ssms-addin

Grantor does not have GRANT permission

I have a gitlab user and a role assigned to it, now the gitlab user needs extra grant permissions.

I am executing the following sentence. [ssms 2012]

GRANT VIEW SERVER STATE to xxx;

ERROR:

Grantor does not have GRANT permission

What is the permission i should give to gitlab user so that it can give grant permissions to another user.

I have also tried this but same error 

grant view server state to xxx with grant option

please tell me as a command

Solution

  • The error is pretty clear - the account that you are using to run the script does not have WITH GRANT permission and therefore it cannot give it to someone else. Check with your DBA.