sys.credentials (Transact-SQL)
Applies to: SQL Server Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
Returns one row for each server-level credential.
Column name | Data type | Description |
---|---|---|
credential_id | int | ID of the credential. Is unique in the server. |
name | sysname | Name of the credential. Is unique in the server. |
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 credential was created. |
modify_date | datetime | Time at which the credential was last modified. |
target_type | nvarchar(100) | Type of credential. Returns NULL for traditional credentials, CRYPTOGRAPHIC PROVIDER for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM). |
target_id | int | ID of the object that the credential is mapped to. Returns 0 for traditional credentials and non-0 for credentials mapped to a cryptographic provider. For more information about external key management providers, see Extensible Key Management (EKM). |
Remarks
For database-level credentials, see sys.database_scoped_credentials.
Permissions
Requires either VIEW ANY DEFINITION
permission or ALTER ANY CREDENTIAL
permission. In addition, the principal must not be denied VIEW ANY DEFINITION
permission.
See Also
sys.database_scoped_credentials
Credentials (Database Engine)
Security Catalog Views (Transact-SQL)
Principals (Database Engine)
CREATE CREDENTIAL (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