Configuring ident authentication for database users
To configure Ident authentication, take the following steps:.
To configure Ident authentication, take the following steps:
-
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;
-
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';
-
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;