[SOLVED] Re: @recompile_invalid_objects.sql _ as GLOGOWNER 2nd run still shows 3 inva

Alan,

Sorry for the late reply. I was occupied with some other stuff the
whole day and only able to try this again just now.
I did remember I was using *SYS* to run the "create_glog_roles.sql"
because no where in the doc. seems to mention I need to use the SYSTEM
user. It worked fine and I just confirmed by running your "select
privilege from dba_sys_privs where grantee='APP_OWNER';", it did
return *15 rows incl. 'Select any table'*.

However I decided to re-run the 'create_glog_roles.sql' again, this
time using the *SYSTEM *user. And guess what, it failed with 4
"ORA-01031: insufficient privileges" errors:

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 execut on dbms_rls to rep_owner

I don't know why I could not use SYSTEM user to run the script. Was
this caused by my previous run of the script as SYS user? The script
should take care of dropping those old ones first I assume.

Now I also remembered that previously when I tried to run
*"create_glog_users.sql"*, I was forced to use "SYSTEM" user because
the script itself prompted for its password. At that time, I also
encountered 4 "ORA-01031: insufficient privileges" errors:

" 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"

Eventually I had to use SYS user to run the above manually one by one.
I guessed I have the following problems:

1) I mixed up the SYS user and SYSTEM user. I don't know which user
OTM requires, I guess most of the time SYSTEM.
2) I am not sure how I can clear up the mess I created so far. Eg. why
using SYSTEM user, I got all those "insufficient privileges" and had
to use SYS, which is abnoraml, i guess for other OTM users?

Again thanks everyone who responded to my questions so far!! Without
you guys, I really want to call it quits.

Zara

You are receiving this mail as a subscriber of the Oracle Transportation
Management SIG List Server. This list is provided by Solution Beacon,
LLC for the Oracle Transportation Management SIG to facilitate distribution
of issues and topics related to Oracle Transportation Management. If you
do not want to receive future mail from the list, send email to
majordomo (AT) solutionbeacon (DOT) net with the words "unsubscribe otmsig" (without
quotes) in the body of the email.
If you need help, please contact mweiss (AT) solutionbeacon (DOT) com.
Thank you!