sys.credentials (Transact-SQL)

Returns one row for each credential.

Column name

Data type

Description

credential_id

int

ID of the credential. Is unique in the server.

name

sysname

Name of the credential. Is unique in the server.

credential_identity

nvarchar(4000)

Name of the identity to use. This will generally be a Windows user. It does not have to be unique.

create_date

datetime

Time at which the credential was created.

modify_date

datetime

Time at which the credential was last modified.

target_type

nvarchar(100)

Type of credential. Returns NULL for traditional credentials, CRYPTOGRAPHIC PROVIDER for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM).

target_id

int

ID of the object that the credential is mapped to. Returns 0 for traditional credentials and non-0 for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM).

Permissions

Requires either VIEW ANY DEFINITION permission or ALTER ANY CREDENTIAL permission. In addition, the principal must not be denied VIEW ANY DEFINITION permission.

See Also

Reference

Security Catalog Views (Transact-SQL)

Catalog Views (Transact-SQL)

CREATE CREDENTIAL (Transact-SQL)

Concepts

Credentials (Database Engine)

Principals (Database Engine)