ALTER CERTIFICATE

Alter a certificate in the database.

Syntax:
      ALTER CERTIFICATE certificate REMOVE PRIVATE KEY

      ALTER CERTIFICATE certificate WITH PRIVATE KEY ( private_key_spec [ ,... ] )
	  
      ALTER CERTIFICATE certificate WITH ACTIVE FOR BEGIN DIALOG = [ON | OFF]

   private_key_spec:
       FILE = 'path_to_private_key' 
       DECRYPTION BY PASSWORD = 'key_password' 
       ENCRYPTION BY PASSWORD = 'password'

Key:
   key_password   Password to decrypt the private key.
   password       Password to encrypt the private key of the certificate in the database.
   REMOVE PRIVATE KEY  The key should no longer be maintained inside the database.
   ACTIVE FOR BEGIN_DIALOG
                  Make the cert available to the initiator of a Service Broker dialog conversation

If password complexity is enforced, the password must be > 8 chars and contain upper/lower case and numeric/ Non-alphanumeric characters.

The private key must correspond to the public key specified by certificate

Requires ALTER permission on the certificate.

Examples

ALTER CERTIFICATE MyCert1 
    WITH PRIVATE KEY (DECRYPTION BY PASSWORD = 'oldCertPassword3456gsf',
    ENCRYPTION BY PASSWORD = 'newCertPassword$214kH');
GO


ALTER CERTIFICATE MyCert2 
    WITH PRIVATE KEY (ENCRYPTION BY PASSWORD = 'newKeyPassword64Jjh7',
    DECRYPTION BY PASSWORD = 'oldKeyPassword706tt');
GO

“If life was fair, Elvis would still be alive and all the impersonators would be dead” ~ Johnny Carson

Related Commands:

CREATE CERTIFICATE
DROP CERTIFICATE
BACKUP CERTIFICATE

Equivalent Oracle commands:

Oracle Wallet:
ALTER SYSTEM SET ENCRYPTION KEY..
ALTER SYSTEM SET WALLET..


© Copyright SS64.com 1999-2014
Some rights reserved