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 Commands:

CREATE ASYMMETRIC KEY
DROP ASYMMETRIC KEY

Equivalent Oracle command:

ALTER USER AUTHENTICATED USING CERTIFICATE