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)
CREATE CREDENTIAL (Transact-SQL)