DISABLE PASSPHRASE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DISABLE PASSPHRASE statement locks an encrypted database (a database created with the createdb dbname -encrypt syntax) and a non-encrypted database which does not have a stashed passphrase. After the DISABLE PASSPHRASE statement is executed, new connections to the encrypted database are not allowed, but existing connections can continue their transactions.
This statement has the following format:
DISABLE PASSPHRASE ['passphrase'] [ON DATABASE dbname]
passphrase
Specifies the passphrase that was entered when the encrypted database was created.
In case of an emergency, when the passphrase is not available but the database should be locked anyway, the database owner can run the statement without specifying the passphrase. To do so, the database owner must have the SECURITY privilege.
Note: The passphrase must always 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.
The database owner must have the SECURITY privilege to run the statement without specifying the passphrase.
Related Statements
ALTER PASSPHRASE
ENABLE PASSPHRASE
Last modified date: 01/27/2026