CODEWITHSUNDEEP
sql-serverssmsssms-2012ssms-addin
user6826691
user6826691

Reputation: 2011

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

Upvotes: 2

Views: 17497

Answers (1)

Icarus
Icarus

Reputation: 63966

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.

Upvotes: 0

Related Questions