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.
See Also
Concepts
Permissions Hierarchy
Securables
Principals
Permissions of Fixed Database Roles
Permissions of Fixed Server Roles
Other Resources
Security Catalog Views (Transact-SQL)