The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Change Your User Password in VSQL with a Meta-Command

Jim_KnicelyJim_Knicely Administrator
edited August 15 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.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.