security-catalog-views-transact-sql.md

description	Security Catalog Views (Transact-SQL)
title	Security Catalog Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	02/27/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	cryptography [SQL Server], catalog views encryption [SQL Server], catalog views catalog views [SQL Server], security security catalog views [SQL Server]
ms.assetid	4d5cf1bf-09a7-4ee0-9dbb-5c584750fc67
author	VanMSFT
ms.author	vanto

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_key_definitions :::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:::

 

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)