ALTER PASSPHRASE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The ALTER PASSPHRASE statement changes the passphrase for an encrypted database and replaces the master key. The master key is used to start the X100 engine and decrypt/encrypt the file where data encryption keys are stored.
Note: This statement is valid only when connected to an encrypted database and requires autocommit to be on.
Note: ALTER PASSPHRASE invalidates previous checkpoints. After the database key and passphrase are updated, a new checkpoint should be taken to provide for disaster recovery.
This statement has the following format:
ALTER PASSPHRASE 'old_passphrase' TO 'new_passphrase' WITH NEWKEY
old_passphrase
Specifies the old passphrase.
new_passphrase
Specifies the new passphrase.
Related Statements
ALTER KEYS
Last modified date: 06/28/2024