Security Catalog Views (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

Security information is exposed in catalog views that are optimized for performance and utility. When possible, use the following catalog views to access catalog metadata.

Database-Level Views

 

Server-Level Views

 

Encryption Views

 

SQL Server Audit Views

 

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Security Center for SQL Server Database Engine and Azure SQL Database
Security-Related Dynamic Management Views and Functions (Transact-SQL)