Integrate with Database User Management (Oracle)
The Database User Management connector integrates Oracle Access Governance with database user management tables in Oracle Database. You can establish a connection between Oracle Database 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 (Oracle) orchestrated system, you should consider the following pre-requisites and tasks.
Certified Components
You can integrate any one of the following Oracle Database types with Oracle Access Governance:
- Exadata V2.
- Oracle Database 12c as single database, pluggable database (PDB), or Oracle RAC implementation.
- Oracle Database 18c as single database, pluggable database (PDB), or Oracle RAC implementation.
- Oracle Database 19c as single database, pluggable database (PDB), or Oracle RAC implementation.
Supported Operations
The Database User Management (Oracle) orchestrated system supports the following operations:
- Create user
- Reset password
- Add roles
- Revoke Roles
- Add privileges
- Revoke privileges
Default Supported Attributes
The Database User Management (Oracle) orchestrated system supports the following default attributes.
Table - Default Attributes - Manage Permission Mode
DBUM User Entity | Target Account Attribute | Oracle Access Governance Account Attribute |
---|---|---|
Return Id | uid | |
Username | name | |
Authentication Type | authenticationType | |
Global DN | globalDN | |
Default Tablespace | defaultTablespace | |
Default Tablespace Quota (in MB) | defaultTablespaceQuotaInMB | |
Temporary Tablespace | temporaryTablespace | |
Profile Name | profileName | |
Account Status | accountStatus | |
Status | status | |
Password | password | |
Role DBUM (Oracle) roles are mapped to Oracle Access Governance entitlements |
||
adminOption | roleAdminOption | |
Privilege DBUM (Oracle) privileges are mapped to Oracle Access Governance entitlements |
||
adminOption | privilegeAdminOption |
Default Matching Rule
The default matching rule for Database User Management (Oracle) orchestrated system
is:Table - Default Matching Rules
Mode | Default Matching Rule |
---|---|
Manage Permissions | userNameOracle = userLogin |
Create a Target System User Account for Database User Management (Oracle) Orchestrated System Operations
Oracle Access Governance requires a user account to access the system during service operations. Depending on the system you are using, you can create the user, and assign specific permissions and roles to them.
For Oracle database:
- Create a service user using the following SQL
statement:
CREATE USER agserviceuser IDENTIFIED BY password DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON users;
- Assign the following permissions and roles to the service user
created:
GRANT SELECT on dba_sys_privs TO agserviceuser; GRANT SELECT on dba_ts_quotas TO agserviceuser; GRANT SELECT on dba_tablespaces TO agserviceuser; GRANT SELECT on dba_users TO agserviceuser; GRANT CREATE USER TO agserviceuser; GRANT ALTER ANY TABLE TO agserviceuser; GRANT GRANT ANY PRIVILEGE TO agserviceuser; GRANT GRANT ANY ROLE TO agserviceuser; GRANT DROP USER TO agserviceuser; GRANT SELECT on dba_roles TO agserviceuser; GRANT SELECT ON dba_profiles TO agserviceuser; GRANT ALTER USER TO agserviceuser; GRANT CREATE ANY TABLE TO agserviceuser; GRANT DROP ANY TABLE TO agserviceuser; GRANT CREATE ANY PROCEDURE TO agserviceuser; GRANT DROP ANY PROCEDURE TO agserviceuser;
Configure
You can establish a connection between Oracle Database 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, specify which type of system you would like to onboard. You can search for the required system by name using the Search field.
- Select the Database User Management (Oracle DB) tile. Once selected, a value of Database User Management (Oracle DB) is displayed on the right hand side under What I've selected.
- Click Next.
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 specified 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 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 (Oracle) Orchestrated System Operations.
- Enter the password of the target 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
- Check the right hand pane to view What I've selected. If you are happy with the details entered, select Add to create the orchestrated system.
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 Oracle 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
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.