Catalog Views of Permissions (Database Engine)

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.

See Also

Reference

Security Catalog Views (Transact-SQL)

Concepts

Permissions Hierarchy (Database Engine)

Securing SQL Server

Principals (Database Engine)

Permissions of Fixed Database Roles (Database Engine)

Permissions of Fixed Server Roles (Database Engine)

Last updated on 2010-10-01