sys.credentials (Transact-SQL)

sys.credentials (Transact-SQL)

 

Updated: August 19, 2015

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns one row for each credential.

Column nameData typeDescription
credential_idintID of the credential. Is unique in the server.
namesysnameName of the credential. Is unique in the server.
credential_identitynvarchar(4000)Name of the identity to use. This will generally be a Windows user. It does not have to be unique.
create_datedatetimeTime at which the credential was created.
modify_datedatetimeTime at which the credential was last modified.
target_typenvarchar(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_idintID 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).

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

sys.database_credentials (Transact-SQL)
Credentials (Database Engine)
Security Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Principals (Database Engine)
CREATE CREDENTIAL (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft