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. OpenText™ Analytics Database 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 database user. Use a GRANT statement that allows the system user user1 to log in using Ident authentication:

    => GRANT AUTHENTICATION v_ident TO user1;