Change Your User Password in VSQL with a Meta-Command

Jim_KnicelyJim_Knicely - Select Field - Administrator
edited August 2019 in Tips from the Team

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/9.2.x/HTML/Content/Authoring/ConnectingToVertica/vsql/Meta-Commands/MetaCommandReference.htm

Have fun!

Tagged:
Sign In or Register to comment.