[chrisplough]

While helping a friend setup an OTM 5.5 instance, I ran into a problem where the create_glog_roles.sql and create_glog_users.sql scripts were failing because the SYSTEM user didn't have privileges to run some of the required commands.

The fix is simple, rather than running both scripts as SYS (which I avoid doing - much like running commands as root on Unix / Linux boxes), or granting more privilleges to the SYSTEM user, you can get buy with just running certain commands as SYS.

Here's the course of events:

1. Login to your OTM app server
2. Change directories to <otm_home_dir>/glog/oracle/script8
3. Sqlplus into your OTM database as the SYSTEM user
4. Run

   @create_glog_roles.sql

5. Sqlplus into your OTM database as the SYS user
6. Run:

   grant SELECT ON DBA_SYNONYMS to app_owner;
   grant execute on dbms_rls to app_owner;
   grant select on sys.v_$context to app_owner;
   GRANT execute on dbms_rls to rep_owner;
   commit;

7. Sqlplus into your OTM database as the SYSTEM user
8. Run:

   @create_glog_users.sql

9. Sqlplus into your OTM database as the SYS user
10. Run:

    grant DBA to glogowner;
    grant DBA to glogdba;
    grant execute on dbms_aqin to glogdba;
    grant execute on dbms_rls to glogowner;
    GRANT EXECUTE ON DBMS_AQIN TO glogowner;
    GRANT execute on dbms_pipe TO glogowner;
    commit;

Hope this helps!
--Chris