sys.database_scoped_credentials (Transact-SQL)
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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho