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)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें