Returns one row for each credential.
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
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 Understanding Extensible Key Management (EKM).
target_id
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 Understanding Extensible Key Management (EKM).
Requires either VIEW ANY DEFINITION permission or ALTER ANY CREDENTIAL permission. In addition, the principal must not be denied VIEW ANY DEFINITION permission.