by Stephen Horsfield
17. January 2008 09:02
Overview
Have you ever wondered how to view object permissions using a query?
Simple example
Try this on a database:
select o.name, u.name, p.permission_name, p.state, p.state_desc
from sys.database_permissions p
inner join sys.all_objects o
on p.major_id = o.object_id
inner join sys.database_principals u
on p.grantee_principal_id = u.principal_id
References
Versions
Metadata
- Categories: SQL Server, IT Management, Software Development, Security
- Additional keywords: information schema, system views, permissions, security, query
- Technorati Tags:
SQL,
SQL Server,
software development,
IT Management,
security,
permissions
Subscribe