BroadSQL BroadSQL
Documentation / Commands / SET PASSWORD

SET PASSWORD

Core command SE PA

change password of the current connection

Arguments

none. Command will prompt for old and new password

Examples

SET PASSWORD

Notes

Changes the password of the current database connection (not the CDF): SET PASSWORD, no arguments - the command runs as an interactive, multi-step prompt.

Refuses to run against the $CDF connection itself (use SET MASTER PASSWORD instead) and refuses if the current connection has uncommitted changes (commit or roll back first). Otherwise it asks for confirmation, re-authenticates with the CDF master password, then prompts for the new connection password twice for verification.

On confirmation, the new password is written to the CDF entry for this connection and the password is changed on the remote database itself; if either step fails, the CDF entry is reverted to the previous password rather than left out of sync with the database.

Last modified in release 4.9.8.

← All commands