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];
/* Set the key */
ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY [password]
Parameters
| Parameter | Description |
|---|---|
| OPEN | Open the Keystore. |
| CLOSE | Close the Keystore. |
| password | The password for accessing the Keystore. |
Examples
Open the Keystore. When the Keystore is in the
openstate, you can access encrypted tables and execute theSET KEYoperation.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***;