Friday, 19 April 2013

How to grant Server level permissions to login in SQL Server

To grant Server level permissions to login in SQL Server (in this example the ‘CONTROL SERVER’ permission):
In SQL Server Management Studio:
Right-click on a SQL Server Instance in Object Explorer -> choose Properties -> Permissions:
grant server permissions in ssms
Choose a login to which you are granting the permission, check the ‘Grant’ (or ‘With Grant’) box next to the permission, and click OK.
To grant “CONTROL SERVER” rights to login “LGN_test” you can issue the following command:
USE master;
GRANT CONTROL SERVER TO LGN_test;
GO

To grant “CONTROL SERVER” rights to login “LGN_test” with the right to grant “CONTROL SERVER” to other logins:
USE master;
GRANT CONTROL SERVER TO LGN_test WITH GRANT OPTION;
GO

No comments:

Post a Comment