Grantor does not have GRANT permission

sql-server ssms ssms-2012 ssms-addin
user6826691 picture user6826691 · Jun 30, 2017 · Viewed 9.4k times · Source

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

Answer

Icarus picture Icarus · Jun 30, 2017

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.

Related questions

Is there a way to expand the column list in a SELECT * from #Temp_Table in SSMS?

As seen here LINK you can hover over the * in a SELECT * from... and a tooltip will come up with a list of the columns represented by that *. Is there a way to copy the text from the tooltip to …

Read More
Results in Grid is not showing in SQL Server

I couldn't see the results in grid pane, so I did the following: Tools > Options > Query Results > Results to Grid > uncheck the "Discard results after execution" check box But still I couldn't see the results in …

Read More
How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?

Read More