sys.dm_cryptographic_provider_properties (Transact-SQL)
Applies to:
SQL Server
Returns information about registered cryptographic providers.
Column name | Data type | Description |
---|---|---|
provider_id | int | Identification number of the cryptographic provider. |
guid | uniqueidentifier | Unique provider GUID. |
provider_version | nvarchar(256) | Version of the provider in the format 'aa.bb.cccc.dd'. |
sqlcrypt_version | nvarchar(256) | Major version of the SQL Server Cryptographic API in the format 'aa.bb.cccc.dd'. |
friendly_name | nvarchar(2048) | Name supplied by the provider. |
authentication_type | nvarchar(256) | WINDOWS , BASIC , or OTHER . |
symmetric_key_support | tinyint | 0 (not supported) 1 (supported) |
symmetric_key_export | tinyint | 0 (not supported) 1 (supported) |
symmetric_key_import | tinyint | 0 (not supported) 1 (supported) |
symmetric_key_persistance | tinyint | 0 (not supported) 1 (supported) |
asymmetric_key_support | tinyint | 0 (not supported) 1 (supported) |
asymmetric_key_export | tinyint | 0 (not supported) 1 (supported) |
symmetric_key_import | tinyint | 0 (not supported) 1 (supported) |
symmetric_key_persistance | tinyint | 0 (not supported) 1 (supported) |
Permissions
The sys.dm_cryptographic_provider_properties view is visible to the public.
See Also
Security Catalog Views (Transact-SQL)
Encryption Hierarchy
Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
Security-Related Dynamic Management Views and Functions (Transact-SQL)
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για