sp_pdw_database_encryption_regenerate_system_keys (Azure Synapse Analytics)
Applies to:
Azure Synapse Analytics
Analytics Platform System (PDW)
Use sp_pdw_database_encryption_regenerate_system_keys
to rotate the certificate and database encryption key for internal databases that are encrypted when TDE is enabled on the appliance. This includes tempdb
. This will succeed only if TDE is enabled.
Syntax
-- Syntax for Azure Synapse Analytics and Parallel Data Warehouse
sp_pdw_database_encryption_regenerate_system_keys
[ ; ]
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
Return code values
0
(success) or 1
(failure).
Remarks
The procedure has no parameters.
This procedure should be used when the traffic in the appliance is low.
Permissions
Requires membership in the sysadmin fixed database role, or CONTROL SERVER permission.
Examples
The following example regenerates the database encryption keys.
EXEC sys.sp_pdw_database_encryption_regenerate_system_keys;
Related content
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za