ALTER ASYMMETRIC KEY

Change properties of an asymmetric key.

Syntax:
       ALTER ASYMMETRIC KEY Asym_Key option

options
    WITH PRIVATE KEY ( password_option [, password_option])
    REMOVE PRIVATE KEY
    ATTESTED BY = 'path_to_dll'
    REMOVE ATTESTED OPTION 

password_options
    ENCRYPTION BY PASSWORD = 'password'
    DECRYPTION BY PASSWORD = 'old_password'

If there is no database master key then ENCRYPTION BY PASSWORD is required.
The database master key must be opened before it can be used to protect a private key.

Examples

ALTER ASYMMETRIC KEY MyKey01
WITH PRIVATE KEY (
DECRYPTION BY PASSWORD = 'fmsA$ek7i82bv64fobjsd2764',
ENCRYPTION BY PASSWORD = '35agRofg0sjlkfssJ454GX72$262');
GO

"Success is not the key to happiness. Happiness is the key to success. If you love what you are doing, you will be successful." ~ Herman Cain

Related:

CREATE ASYMMETRIC KEY

DROP ASYMMETRIC KEY
Password generator
Equivalent Oracle command: ALTER USER AUTHENTICATED USING CERTIFICATE


 
Copyright © 1999-2024 SS64.com
Some rights reserved