Changing a User's Password
A superuser can change another user's database account, including reset a password, with the ALTER USER statement.
Making changes to a database user account with does not affect current sessions.
=> ALTER USER Fred IDENTIFIED BY 'newpassword';
In the above command, Fred's password is now newpassword.
Note: Non-DBA users can change their own passwords using the IDENTIFIED BY 'new-password' option along with the REPLACE 'old-password' clause. See ALTER USER for details.
Changing a User's MC Password
On MC, users with ADMIN or IT privileges can reset a user's non-LDAP password from the MC interface.
Non-LDAP passwords on MC are for MC access only and are not related to a user's logon credentials on the Vertica database.
- Sign in to Management Console and navigate to MC Settings > User management.
- Click to select the user to modify and click Edit.
- Click Edit password and enter the new password twice.
- Click OK and then click Save.