security-catalog-views-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs
Security Catalog Views (Transact-SQL)	Security Catalog Views (Transact-SQL)	VanMSFT	vanto	05/24/2022	sql	system-objects	reference	cryptography [SQL Server], catalog views encryption [SQL Server], catalog views catalog views [SQL Server], security security catalog views [SQL Server]	TSQL

Security Catalog Views (Transact-SQL)

[!INCLUDE SQL Server]

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

:::row::: :::column::: sys.database_permissions :::column-end::: :::column::: sys.database_scoped_credentials :::column-end::: :::row-end::: :::row::: :::column::: sys.database_principals :::column-end::: :::column::: sys.master_key_passwords :::column-end::: :::row-end::: :::row::: :::column::: sys.database_role_members :::column-end::: :::column::: sys.user_token :::column-end::: :::row-end:::

 

Server-Level Views

:::row::: :::column::: sys.credentials :::column-end::: :::column::: sys.server_principals :::column-end::: :::row-end::: :::row::: :::column::: sys.login_token :::column-end::: :::column::: sys.server_role_members :::column-end::: :::row-end::: :::row::: :::column::: sys.securable_classes :::column-end::: :::column::: sys.sql_logins :::column-end::: :::row-end::: :::row::: :::column::: sys.server_permissions :::column-end::: :::column::: sys.system_components_surface_area_configuration :::column-end::: :::row-end:::

 

Encryption Views

:::row::: :::column::: sys.asymmetric_keys :::column-end::: :::column::: sys.cryptographic_providers :::column-end::: :::row-end::: :::row::: :::column::: sys.certificates :::column-end::: :::column::: sys.key_encryptions :::column-end::: :::row-end::: :::row::: :::column::: sys.column_encryption_key_values :::column-end::: :::column::: sys.openkeys :::column-end::: :::row-end::: :::row::: :::column::: sys.column_encryption_keys :::column-end::: :::column::: sys.security_policies (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: sys.column_master_keys :::column-end::: :::column::: sys.security_predicates (Transact-SQL) :::column-end::: :::row-end::: :::row::: :::column::: sys.crypt_properties :::column-end::: :::column::: sys.symmetric_keys :::column-end::: :::row-end:::

 

SQL Server Audit Views

:::row::: :::column::: sys.server_audits :::column-end::: :::column::: sys.server_file_audits :::column-end::: :::row-end::: :::row::: :::column::: sys.server_audit_specifications :::column-end::: :::column::: sys.server_audit_specifications_details :::column-end::: :::row-end::: :::row::: :::column::: sys.database_audit_specifications :::column-end::: :::column::: sys.database_audit_specification_details :::column-end::: :::row-end:::

Ledger Views

:::row::: :::column::: sys.database_ledger_transactions :::column-end::: :::column::: sys.database_ledger_blocks :::column-end::: :::row-end::: :::row::: :::column::: sys.ledger_table_history :::column-end::: :::column::: sys.ledger_column_history :::column-end::: :::row-end::: :::row::: :::column::: sys.database_ledger_digest_locations :::column-end::: :::row-end:::

 

Permissions

[!INCLUDEssCatViewPerm] 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)