Integrate with Database User Management (DB2)
The Database User Management (DB2) connector integrates Oracle Access Governance with IBM DB2 database user management tables. You can establish a connection between IBM DB2 and Oracle Access Governance by entering connection details and configuring the connector. To achieve this, use the Orchestrated Systems functionality available in the Oracle Access Governance Console.
Prerequisites
Before you install and configure a Database User Management (DB2) orchestrated system, you should consider the following pre-requisites and tasks.
Certified Components
The DB2 system can be any of the following:
- IBM DB2 UDB 9.x.
Supported Operations
- Create user
- Add schema
- Revoke schema
- Add tablespace
- Revoke tablespace
Create a DB2 System User Account for Database User Management (DB2) Orchestrated System Operations
Oracle Access Governance requires a user account to access the DB2 system during service operations. Depending on the system you are using, you can create the user in your system and assign specific permissions and roles to the user.
For DB2 database:
- Create a DB2 user
agserviceuser
at the OS level. - 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;
Configure
You can establish a connection between IBM DB2 and Oracle Access Governance by entering connection details and configuring your database environment. To achieve this, use the Orchestrated Systems functionality available in the Oracle Access Governance Console.
Navigate to the Orchestrated Systems Page
- From the Oracle Access Governance navigation menu icon
, select Service Administration → Orchestrated Systems.
- Click the Add an orchestrated system button to start the workflow.
Select system
On the Select system step of the workflow, you can specify which type of database you would like to onboard.
- Select Database User Management (DB2).
Enter details
On the Enter Details step of the workflow, enter the details for the orchestrated system:
- Enter a name for the database you want to connect to in the What do you want to call this system? field.
- Enter a description for the database in the How do you want to describe this system? field.
- Click Next.
Configure
On the Configure step of the workflow, enter the configuration details required to allow Oracle Access Governance to connect to the IBM DB2 database.
- 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.
- In the User Name field, enter the IBM DB2 user you will use to connect to the database. This is the user you created in Create a DB2 System User Account for Database User Management (DB2) Orchestrated System Operations.
- Enter the password of the IBM DB2 database user in the Password field. Confirm the password in the Confirm password field.
- In Connection Properties enter any connection properties in the format prop1=val1#prop2=val2
- 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.
- Check the right hand pane to view What I've selected. If you are happy with the details entered, click Add.
Finish up
On the Finish Up step of the workflow, you are asked to download the agent you will use to interface between Oracle Access Governance and IBM DB2 database. Select the Download link to download the agent zip file to the environment in which the agent will run.
After downloading the agent, follow the instructions explained in the Agent Administration article.
- Customize before enabling the system for data loads
- Activate and prepare the data load with the provided defaults
Post Configuration
For DB2 Database system to integrate with Oracle Access Governance, driver jar needs to be registered with the agent. For more information, refer Custom Jar Support.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.