Export (0) Print
Expand All

sys.credentials (Transact-SQL)

Returns one row for each credential.

Column name Data type Description

credential_id

int

ID of the credential. Is unique within the server

name

sysname

Name of the credential. Is unique within the server

credential_identity

nvarchar(4000)

Name of the identity to be used. This will generally be a Windows user. It need not be unique.

create_date

datetime

Time at which the credential was created

modify_date

datetime

Time at which the credential was last modified

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