Create oracle full access user

create role OIM_Admin;
-- usualy it is bad practices grant dba role
grant dba to OIM_ADMIN;

-- alternative way 
grant all privileges to OIM_ADMIN;
-- or 
set pagesize 0
spool grant_rw.sql
select 'grant all privileges on '||owner||'.'||table_name||' to OIM_ADMIN;' from all_tables;
select 'grant select on '||owner||'.'||view_name||' to OIM_ADMIN;' from all_views;
spool off
@grant_rw.sql

CREATE USER admin_user  PROFILE "DEFAULT"
    IDENTIFIED BY "somepassword" DEFAULT TABLESPACE "USERS"
    TEMPORARY TABLESPACE "TEMP"
    ACCOUNT UNLOCK;

GRANT CREATE SESSION, ALTER SESSION TO admin_user;

grant OIM_ADMIN to admin_user;