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 an emergency situation when the passphrase is not available, the database owner can run this statement without passphrase to lock the database. The database administrator must have the SECURITY privilege to perform this task.
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: 12/19/2024