security-catalog-views-transact-sql.md

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

Security Catalog Views (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

sys.database_permissions	sys.database_scoped_credentials
sys.database_principals	sys.master_key_passwords
sys.database_role_members	sys.user_token

Server-Level Views

sys.credentials	sys.server_principals
sys.login_token	sys.server_role_members
sys.securable_classes	sys.sql_logins
sys.server_permissions	sys.system_components_surface_area_configuration

Encryption Views

sys.asymmetric_keys	sys.cryptographic_providers
sys.certificates	sys.key_encryptions
sys.column_encryption_key_values	sys.openkeys
sys.column_encryption_keys	sys.security_policies (Transact-SQL)
sys.column_master_key_definitions	sys.security_predicates (Transact-SQL)
sys.crypt_properties	sys.symmetric_keys

SQL Server Audit Views

sys.server_audits	sys.server_file_audits
sys.server_audit_specifications	sys.server_audit_specifications_details
sys.database_audit_specifications	sys.database_audit_specification_details

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)