Creating user in Vertica

You can create a user and assign password by following ” Creating user in Vertica”  and

dbadmin=> create user jim identified by 'pluto';
dbadmin=> \q
bash-3.2$ vsql -U jim -w pluto
Welcome to vsql, the Vertica Analytic Database v5.0.11-0 interactive terminal.

Type:  \h for help with SQL commands
       \? for help with vsql commands
       \g or terminate with semicolon to execute query
       \q to quit


Once user user is created you can login via VSQL ( Vertica SQL Client)

Leave a Reply