I was looking out to determine Permissions for all Users at an Object Level in a database. Here’s the query to do so:
sysU.name, sysO.name, permission_name ,
granted_by = suser_name(grantor_principal_id)
JOIN sys.sysusers sysU on grantee_principal_id = uid
JOIN sys.sysobjects sysO on major_id = id
order by sysU.name
If anyone knows a better way, I would love to hear it!
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|