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

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.