Integrate with Database User Management (DB2)

The Database User Management (DB2) connector integrates Oracle Access Governance with database user management tables in Oracle Database. You can establish a connection between Oracle Database (DB2) and Oracle Access Governance by entering connection details and configuring the connector. To achieve this, use the Connected Systems functionality available in the Oracle Access Governance Console.

Preinstall

Before you install and configure a Database User Management (DB2) connected system, you should consider the following pre-requisites and tasks.

Certified Components

The target system can be any one of the following:

  • IBM DB2 UDB 9.x.

Supported Connector Operations

The Database User Management (DB2) connected system supports the following connector operations:
  • User Management
    • Create user
  • Entitlement Grant Management
    • Add schema
    • Revoke schema
    • Add tablespace
    • Revoke tablespace

Create a Target System User Account for Database User Management (DB2) Connected System Operations

Oracle Access Governance requires a user account to access the target system during service operations. Depending on the target system you are using, you can create the user in your target system and assign specific permissions and roles to the user.

For Oracle database (DB2):

  1. Create a user agserviceuser at the OS level.
  2. Assign the following permissions and roles to the service user created:
    GRANT SELECT on TABLE syscat.schemata TO agserviceuser;
    
    GRANT SELECT on TABLE syscat.tablespaces TO agserviceuser;
    
    GRANT CREATEIN,DROPIN,ALTERIN ON SCHEMA 'SCHEMA_NAME' TO agserviceuser;
    
    GRANT CONNECT,BINDADD,DBADM,CREATETAB,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT ON DATABASE TO agserviceuser;

Install

You can establish a connection between Oracle Database(DB2) and Oracle Access Governance by entering connection details and configuring your database environment. To achieve this, use the Connected Systems functionality available in the Oracle Access Governance Console.

Navigate to the Connected Systems Page

Navigate to the Connected Systems page of the Oracle Access Governance Console, by following these steps:
  1. From the Oracle Access Governance navigation menu icon Navigation menu, select Service Administration → Connected Systems.
  2. Click the Add a connected system button to start the workflow.

Add a Connected System

To start the add a connected system workflow, you should select the type of system that you would like to connect with Oracle Access Governance:

Select the Add button on the Would you like to connect to a database management system?tile.

Select system

On the Select system step of the workflow, you can specify which type of database you would like to onboard.

  1. Select Database User Management (DB2).

Enter details

On the Enter Details step of the workflow, enter the details for the connected system:

  1. Enter a name for the database you want to connect to in the What do you want to call your database? field.
  2. Enter a description for the database in the How do you want to describe this database? field.
  3. Click Next.

Configure

On the Configure step of the workflow, enter the configuration details required to allow Oracle Access Governance to connect to the target database.

  1. In the Easy Connect URL for Database field, enter the connect string for the database you want to integrate with Oracle Access Governance, in the format host/port/database service/sid.
  2. In the User Name field, enter the DB user you will use to connect to the database. This is the user you created in Create a Target System User Account for Database User Management (DB2) Connected System Operations.
  3. Enter the password of the target database user in the Password field. Confirm the password in the Confirm password field.
  4. In Connection Properties enter any connection properties in the format prop1=val1#prop2=val2
  5. In Custom Jar Details enter the jar name and the jar checksum in the format <jarName>::<jarChecksum.
    For example:
    db2jcc.jar::c8520f145b428b1133b771bb2c70a6f0f546c9f0655f9de5de2e7b64d5ede786911ad50b543846154fe373dead78d38fb6dded560e0de4c4e8ccbbf0a06b6c1e

    For more information on custom jar support, refer Custom Jar Support.

  6. Check the right hand pane to view What I've selected. If you are happy with the details entered, click Add.
  7. On the Configure step, click on the Download link to download the agent zip file to the environment on which the agent runs.
  8. Click I'm done to create the connected system.

    After downloading the agent, follow the instructions explained in the Agent Administration article.

Finish up

The Finish Up step of the workflow is not required for Database User Management (DB2).

Postinstall

For DB2 Database system to integrate with AGCS, driver jar needs to be registered with the agent. For more information, refer Custom Jar Support.