Edit

sys.database_scoped_credentials (Transact-SQL)

  • Article

Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

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

Column name Data type Description
name sysname Name of the database scoped credential. Is unique in the database.
credential_id int ID 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
Column name Data type Description
name sysname Name of the database scoped credential. Is unique in the database.
credential_id int ID of the database scoped credential. Is unique in the database.
principal_id int ID of the database principal who owns the key.
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)