Change Your User Password in VSQL with a Meta-Command

Posted August 14, 2019 by Jim Knicely, Vertica Principal Solution Architect

Compass rose with true north pointing to "Helpful Tips" text
The \password VSQL meta-command can be used to change your database user’s password!

Example: dbadmin=> SELECT user; current_user -------------- jim (1 row) dbadmin=> \password Changing password for "jim" Old password: New password: Retype new password: Password changed. The admin user can change the database password for any user: dbadmin=> SELECT user; current_user -------------- dbadmin (1 row) dbadmin=> \password jim Changing password for "jim" New password: Retype new password: Password changed. Helpful Link: https://www.vertica.com/docs/latest/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/MetaCommandReference.htm

Have fun!