All Products
Search
Document Center

ALTER KEYSTORE

Last Updated: Jun 18, 2021

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

Parameter

Description

keystore_name

Specifies the keystore name.

password

Specifies the password of the keystore for access control.

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;