Purpose
This statement is used to modify the attributes of a keystore, including opening and closing a keystore, changing the password of a keystore, and generating a key for a keystore.
Syntax
/* Open or close a keystore */
ADMINISTER KEY MANAGEMENT SET KEYSTORE [OPEN | CLOSE] IDENTIFIED BY [password];
/* Modify a keystore */
ADMINISTER KEY MANAGEMENT ALTER KEYSTORE PASSWORD IDENTIFIED BY password SET new_password;
/* Set a primary key */
ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY [password]
Parameters
| Parameter | Description |
|---|---|
| OPEN | Opens a keystore. |
| CLOSE | Closes a keystore. |
| password | The password for accessing the control keystore. The password for the keystore must be at least 1 character long and cannot exceed 128 characters in length. It must start with an English letter. |
Examples
Open a 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***;Change the primary key stored in the keystore.
obclient> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY **1***;