select *
from sys.database_permissions p
inner JOIN sys.database_principals dp
on p.grantee_principal_id = dp.principal_id
where class_desc = 'schema'
Subscribe to:
Post Comments (Atom)
Joe's Knowledge Base - a collection of various tips-n-tricks for SQL Server. Note: best effort to site sources where applicable, otherwise curated from BOL/MSDN or self-created.
No comments:
Post a Comment