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

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

Other Resources

Credentials
Principals

Help and Information

Getting SQL Server 2005 Assistance