Required WIMS Oracle schema roles and privileges for a schema - OPSROOT and all facilities.

Roles:

"    CONNECT"

Privileges:

"    ADMINISTER DATABASE TRIGGER"
"    ALTER DATABASE"
"    ALTER PROFILE"
"    ALTER RESOURCE COST"
"    ALTER ROLLBACK SEGMENT"
"    ALTER SESSION"
"    ALTER SYSTEM"
"    ALTER TABLESPACE"
"    ALTER USER"
"    AUDIT SYSTEM"
"    BECOME USER"
"    CREATE SESSION"
"    CREATE CLUSTER"
"    CREATE DATABASE LINK"
"    CREATE DIMENSION"
"    CREATE INDEXTYPE"
"    CREATE LIBRARY"
"    CREATE MATERIALIZED VIEW"
"    CREATE OPERATOR"
"    CREATE PROCEDURE"
"    CREATE PROFILE"
"    CREATE PUBLIC DATABASE LINK"
"    CREATE PUBLIC SYNONYM"
"    CREATE ROLE"
"    CREATE ROLLBACK SEGMENT"
"    CREATE SEQUENCE"
"    CREATE SESSION"
"    CREATE SYNONYM"
"    CREATE TABLE"
"    CREATE TABLESPACE"
"    CREATE TRIGGER"
"    CREATE TYPE"
"    CREATE USER"
"    CREATE VIEW"
"    DROP PROFILE"
"    DROP PUBLIC DATABASE LINK"
"    DROP PUBLIC SYNONYM"
"    DROP ROLLBACK SEGMENT"
"    DROP TABLESPACE"
"    FORCE TRANSACTION"
"    GLOBAL QUERY REWRITE"
"    MANAGE TABLESPACE"
"    QUERY REWRITE"
"    RESTRICTED SESSION"
"    UNLIMITED TABLESPACE"

This list is a result from running this query, found from

http://www.adp-gmbh.ch/ora/misc/recursively_list_privilege.html

select
  lpad(' ', 2*level) || granted_role "User, his roles and privileges"
from
  (
  /* THE USERS */
    select 
      null     grantee, 
      username granted_role
    from 
      dba_users
    where
      username like upper('%&enter_username%')
  /* THE ROLES TO ROLES RELATIONS */ 
  union
    select 
      grantee,
      granted_role
    from
      dba_role_privs
  /* THE ROLES TO PRIVILEGE RELATIONS */ 
  union
    select
      grantee,
      privilege
    from
      dba_sys_privs
  )
start with grantee is null
connect by grantee = prior granted_role;

You can copy-paste this query into SQLDeveloper and run it to produce the results