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';
CREATE USER
dbadmin=> \q
bash-3.2$ vsql -U jim -w pluto
SET
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

jim=>

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

Leave a Reply