The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Change Your User Password in VSQL with a Meta-Command

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.
Have fun!
Tagged:
0