OIM Bulk Load Utility: DB Permissions

The latest version of Oracle Identity Manager (9.1.0.2) comes with a tool called the Bulk Load Utility, designed to quickly import large numbers of users into the system. The utility is backwards compatible with OIM 9.1.0.1.
There are a few tweaks required to get the Bulk Load Utility functioning as it does not work straight out of the box.
First, you will need to create a table space in the database. The code below should do, but feel free to adjust as needed:


create tablespace tspace logging datafile '/opt/oracle/tspace.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local;
Second, the utility runs under the OIM user account and, by default,  does not have sufficient privileges causing the tool to error out. To fix this,  try the following:
grant CREATE ANY SYNONYM, CREATE ANY TRIGGER, CREATE ANY TYPE, CREATE DATABASE LINK, CREATE JOB, CREATE LIBRARY, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE , CREATE TRIGGER , CREATE VIEW to oimuser;

More Here


Courtesy:http://www.idmworks.com/blog/oim-bulk-load-utility-db-permissions