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.

  1. Sign in to Management Console and navigate to MC Settings > User management.
  2. Click to select the user to modify and click Edit.
  3. Click Edit password and enter the new password twice.
  4. Click OK and then click Save.