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)