Configuring hash authentication

The hash authentication method allows users to authenticate with a password.

Vertica stores hashes (SHA-512 by default) of passwords and not the passwords themselves. For details, see Password hashing algorithm.

1. Create an authentication record with the hash method. Authentication records are automatically enabled after creation. For example, to create the authentication record v_hash for users that log in from the IP address 192.0.2.0/24:

   => CREATE AUTHENTICATION v_hash METHOD 'hash' HOST '192.0.2.0/24';
   

2. Associate the v_hash authentication method with the desired users or roles, using a GRANT statement:

   => GRANT AUTHENTICATION v_hash to user1, user2, ...;