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 Understanding 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 Understanding 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.