Configuring ident authentication for database users

To configure Ident authentication, take the following steps:.

To configure Ident authentication, take the following steps:

  1. Create an authentication method that uses Ident.

    The Ident server must be installed on the same computer as your database, so specify the keyword LOCAL. Vertica requires that the Ident server and database always be on the same computer as the database.

    => CREATE AUTHENTICATION v_ident METHOD 'ident' LOCAL;
    
  2. Set the Ident authentication parameters, specifying the system users who should be allowed to connect to your database.

    => ALTER AUTHENTICATION v_ident SET system_users='user1:user2:user3';
    
  3. Associate the authentication method with the Vertica user. Use a GRANT statement that allows the system user user1 to log in using Ident authentication:

    => GRANT AUTHENTICATION v_ident TO user1;