5
(1)

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:

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.