DISABLE PASSPHRASE (X100 Only)
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). 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.
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
ENABLE PASSPHRASE
Last modified date: 04/03/2024