DISABLE PASSPHRASE Examples
1. Lock an encrypted database with passphrase when connected to the database:
DISABLE PASSPHRASE 'my secret passphrase' \g
2. Lock an encrypted database with passphrase when connected to iidbdb:
DISABLE PASSPHRASE 'my secret passphrase' ON DATABASE mydb \g
3. In an emergency case, the database owner can run the statement without passphrase:
a. When connected to the database:
DISABLE PASSPHRASE \g
b. When connected to iidbdb:
DISABLE PASSPHRASE ON DATABASE mydb \g
Last modified date: 12/19/2024