Was this helpful?
ENABLE PASSPHRASE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The ENABLE PASSPHRASE statement unlocks an encrypted database (a database created with the createdb dbname -encrypt syntax).
This statement has the following format:
ENABLE PASSPHRASE passphrase [ON DATABASE dbname]
passphrase
Specifies the passphrase that was entered when the encrypted database was created.
Note:  If the passphrase contains blanks, it must be enclosed in single quotes. For example: 'my passphrase'.
ON DATABASE dbname
Specifies the database name. This option is valid only when connected to the iidbdb database.
Permissions
You must be the database administrator or have the SECURITY privilege.
Related Statements
DISABLE PASSPHRASE
Last modified date: 11/09/2022