I'm playing around with Vertica 7.0.1 and noticed a weird issue while trying to change users in vsql. If the user has a password, then Vertica does not ask for the password and presents an error.
If the user does not have a pw I can change to the user fine:
Code: Select all
dbadmin=> create user julie;
CREATE USER
dbadmin=> \c dbadmin julie;
You are now connected to database "dbadmin" as user "julie".
dbadmin=> \c dbadmin dbadmin
You are now connected to database "dbadmin" as user "dbadmin".
dbadmin=> drop user julie;
DROP USER
Code: Select all
dbadmin=> create user julie identified by 'julie1';
CREATE USER
dbadmin=> \c dbadmin julie
FATAL 3781: Invalid username or password
Previous connection kept