T-SQL script to check server level permission in SQL Server

2 Oct, 2022

T-SQL script to check server level permission in SQL Server

MSSQL, T-SQL Scripts SQL server, SQL server access, view server state

Below query script can be used to check server level access for specified user in SQL Server.

SELECT spr.name as grantee_name, sp.state_desc, sp.permission_name FROM
sys.server_permissions AS sp JOIN sys.server_principals AS spr ON
sp.grantee_principal_id = spr.principal_id
where spr.name not like '%##%' and spr.name='testuser'

Sample Output: