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.

• sys.database_permissions

• sys.server_permissions

See Also

Reference

Security Catalog Views (Transact-SQL)

Concepts

Permissions Hierarchy (Database Engine)

Securing SQL Server

Securables

Principals (Database Engine)

Permissions of Fixed Database Roles (Database Engine)

Permissions of Fixed Server Roles (Database Engine)