Export (0) Print
Expand All

sys.credentials (Transact-SQL)

Returns one row for each credential.

Applies to: SQL Server (SQL Server 2008 through current version).

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

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft