IM InfoSphere Identity Insight, Version 8.0

Configuring client authentication for Oracle databases

Set up Oracle to use client authentication.

  1. Set the following global database server configuration options:
    1. Set os_authent_prefix to the value OPS$.
    2. Set remote_os_authent to the value TRUE.
  2. Create Oracle database users so the user can use both external and database authentication methods. Example syntax:
    CREATE USER OPS$<user> IDENTIFIED BY <dbpassword> DEFAULT 
    TABLESPACE <tablespace> TEMPORARY TABLESPACE <temp-tablespace> 
    QUOTA UNLIMITED ON <tablespace>;
    GRANT CONNECT, RESOURCE TO OPS$<user>;
  3. Ensure you have the Oracle JDBC Type-2 Driver in addition to the standard Oracle JDBC Type-4 Driver. For Oracle 10g this should be contained in the file ojdbc14.zip. For Oracle 11g this should be contained in the file ojdbc16.zip
  4. Enable trusted authentication when installing the product. Provide a username with the OPS$ prefix when asked for database credentials in the product installer.


Feedback

Last updated: 2009