ALTER KEYSTORE

Description

The ALTER KEYSTORE statement modifies keystore attributes, such as enabling or disabling the keystore, changing the keystore password, and generating a secret key for the keystore.

Syntax

## Enable or disable KEYSTORE.
ADMINISTER KEY MANAGEMENT SET [keystore_name] OPEN IDENTIFIED BY [password];
ADMINISTER KEY MANAGEMENT SET [keystore_name] CLOSE IDENTIFIED BY [password];

## Set the secret key.
ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY [password]

Parameter description

Examples

• Enable the keystore. You can access the encrypted table and set the key only when the keystore is in the open state.

ADMINISTER KEY MANAGEMENT SET my_keystore OPEN IDENTIFIED BY abcCBAK123;

• Update the master key that is stored in the keystore.

ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY abcCBAK123;