I was looking out to determine Permissions for all Users at an Object Level in a database. Here’s the query to do so:
SELECT
sysU.name, sysO.name, permission_name ,
granted_by = suser_name(grantor_principal_id)
FROM sys.database_permissions
JOIN sys.sysusers sysU on grantee_principal_id = uid
JOIN sys.sysobjects sysO on major_id = id
order by sysU.name
OUTPUT
If anyone knows a better way, I would love to hear it!
No comments:
Post a Comment