Ócáid
Mar 31, 11 PM - Apr 2, 11 PM
An ócáid foghlama SQL, Fabric and Power BI is mó. Márta 31 – 2 Aibreán. Bain úsáid as cód FABINSIDER chun $ 400 a shábháil.
Cláraigh inniusys.database_scoped_credentials (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later versions
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL database in Microsoft Fabric
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 |
Requires 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)
sys.credentials (Transact-SQL)
Acmhainní breise
Oiliúint
Modúl
Explore security practices for Azure SQL Database - Training
Learn how security works in Azure SQL Database, the key concepts, and practical examples to help developers effectively utilize Azure SQL Database in their cloud-based applications.
Deimhniú
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.