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)
Opinia
https://aka.ms/ContentUserFeedback.
Dostępne już wkrótce: W 2024 r. będziemy stopniowo wycofywać zgłoszenia z serwisu GitHub jako mechanizm przesyłania opinii na temat zawartości i zastępować go nowym systemem opinii. Aby uzyskać więcej informacji, sprawdź:Prześlij i wyświetl opinię dla