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 ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για