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