sys.database_scoped_credentials (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabaseyesAzure SQL Data Warehouse noParallel Data Warehouse

Returns one row for each database scoped credential in the database.

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

Permissions

Requires CONTROL permission on the database.

See Also

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)
sys.credentials (Transact-SQL)