Catalog Views of Permissions

Permissions information is made available by using catalog views that are optimized for performance and utility. The following catalog views return lists of explicit grants and denies.

• sys.database_permissions
• sys.server_permissions

See Also

Concepts

Permissions Hierarchy
Securables
Principals
Permissions of Fixed Database Roles
Permissions of Fixed Server Roles

Other Resources

Security Catalog Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance