Returns one row for each database scoped credential in the database.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use sys.database_scoped_credentials instead.
|Column name||Data type||Description|
|credential_id||int||ID of the database scoped credential. Is unique in the database.|
|name||sysname||Name of the database scoped credential. Is unique in the database.|
|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 database scoped credential was created.|
|modify_date||datetime||Time at which the database scoped credential was last modified.|
|target_type||nvarchar(100)||Type of database scoped credential. Returns NULL for database scoped credentials.|
|target_id||int||ID of the object that the database scoped credential is mapped to. Returns 0 for database scoped credentials|
CONTROL permission on the database.
Credentials (Database Engine)
CREATE DATABASE SCOPED CREDENTIAL (Transact-SQL)
ALTER DATABASE SCOPED CREDENTIAL (Transact-SQL)
DROP DATABASE SCOPED CREDENTIAL (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)