2 Oct, 2022
T-SQL script to check server level permission in SQL Server 5 (1)
MSSQL, T-SQL Scripts , ,

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 '%##%'
… Read the rest