SQL Language Guide > SQL Language Guide > SQL Statements > ALTER PASSPHRASE > ALTER PASSPHRASE Example
Was this helpful?
ALTER PASSPHRASE Example
In the unlocked database (see ENABLE PASSPHRASE), set autocommit on first:
SET AUTOCOMMIT ON;
Then change the old passphrase to a new one:
ALTER PASSPHRASE 'InteractiveGraphicsRetrievalSystem' to 'InCoddWeTrustSoBringYourData' WITH NEWKEY;
The new passphrase must be used to lock and unlock the database going forward.
Last modified date: 12/06/2024