List of Security-Related Dynamic Management Views

from http://www.sqlserverspecialists.com/2013/03/list-of-security-related-dynamic.html

 

sys.asymmetric_keys

Returns a row for each asymmetric key, containing (by default) both a public and private key. (The private key is protected by the database master key.)

 

sys.certificates

Returns a row for each certificate in the database. A certificate is a database-level security object loaded from a file or an assembly which follows the X.509 standard.

 

sys.credentials

Returns a row for each credential in the instance. A credential is a record containing authentication information needed to connect to resource external to SQL Server, usually including a Windows user and password.

 

sys.crypt_properties

Returns a row for each cryptographic property associated with each symmetric or asymmetric key on the instance.

 

sys.database_permissions

Returns a row for each permission or counter-permission in the database (that is, permissions on a column that are different from the corresponding higher-level, object permission).

 

sys.database_principals

Returns a row for each principal in the database. A principal is an entity (such as a Windows login, a SQL Server login,or an application role)

 

Sys.dm_audit_actions

TBD

 

Sys.dm_cryptographic_provider_keys

Returns information about keys provided by an Extensible Key Management provider.

 

Sys.dm_cryptographic_provider_sessions

Returns information about a cryptographic provider for either the current connection or all cryptographic connections.

 

Sys.dm_database_encryption_keys

Returns information about the encryption state of a database and its encryption keys.

 

Sys.dm_provider_algorithms

Returns options and details, including the algorithm details, of a specific Extensible Key Management provider.

 

Sys.dm_provider_properties

Returns a row for each registered cryptographic provider.

 

Sys.dm_server_audit_status

TBD

 

sys.key_encriptions

Returns a row for each symmetric key encryption that was created using the statement CREATE SYMMETRIC KEY with ENCRYPTION BY.

 

sys.login_token

Returns a row for each server principle (such as a Windows login, SQL Server login, or application role) that is part of the login token.

 

sys.master_key_passwords

Returns a row for each database master key password (used to protect the master keys kept in the credential store) created with the system stored procedure

 

sp_control_dbmasterkey_password stored procedure.

sys.openkeys

Returns a row for each encryption key that is open in the current session.

 

sys.securable_classes

Returns a list of all securable classes on the instance.

 

sys.server_permissions

Returns a row for each server permission granted, including servers, server principals and endpoints.

 

sys.server_principals

Returns a row for each server-level principal, such as Windows and SQL Server logins, as well as logins mapped to

certificates and asymmetric keys.

 

sys.server_role_members

Returns a row for each member of each fixed server role on the instance.

 

sys.sql_logins

Returns a row for each SQL login on the instance.

 

sys.system_components_surface_area_configuration

Returns a row for each executable system object, like a stored procedure or user-defined function, that can be enabled or disabled by a surface area configuration component.

 

sys.symmetric_keys

Returns a row for each symmetric key created using the statement CREATE SYMMETRIC KEY.

 

sys.user_token

Returns a row for each database principal (such as a Windows login, SQL Server login, or application role) that is part of the user token.