Applies to: SQL Server Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
Returns one row for each server-level 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).|
For database-level credentials, see sys.database_scoped_credentials.
VIEW ANY DEFINITION permission or
ALTER ANY CREDENTIAL permission. In addition, the principal must not be denied
VIEW ANY DEFINITION permission.
Credentials (Database Engine)
Security Catalog Views (Transact-SQL)
Principals (Database Engine)
CREATE CREDENTIAL (Transact-SQL)