Purpose
This statement is used to modify Keystore properties, including opening/closing the Keystore, changing the Keystore password, and generating a Keystore key.
Syntax
/* Open or close the Keystore */
ADMINISTER KEY MANAGEMENT SET KEYSTORE [OPEN | CLOSE] IDENTIFIED BY [password];
/* Modify the Keystore */
ADMINISTER KEY MANAGEMENT ALTER KEYSTORE PASSWORD IDENTIFIED BY password SET new_password;
/* Set the master key */
ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY [password]
Parameters
| Parameter | Description |
|---|---|
| OPEN | Opens the Keystore. |
| CLOSE | Closes the Keystore. |
| password | Specifies the password for accessing the Keystore. The Keystore password cannot exceed 128 characters and must start with a letter. |
Examples
Open the Keystore. You can access encrypted tables and perform the
SET KEYoperation only when the Keystore is in theopenstate.obclient> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY **1***;Update the master key stored in the Keystore.
obclient> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY **1***;