by All,
I keep getting the following error when I try to
execute any job in the job queue. It basically
fails because of insufficient privileges. This
job is part of a Symmetric Replication environment.
Repadmin has all the privileges required as I ran
the dbms_repcat procedure which sets him up as the
global administrator.
If more info is required please let me know.
TIA,
Phil M.
Partial contents of job queue
1 select substr(job, 1,5) job, substr(log_user, 1, 10) log_user,
2 substr(priv_user, 1, 10) priv_user, substr(schema_user, 1,
10) schem
a_us,
3 broken, failures, what
4* from dba_jobs
comisp2> /
JOB LOG_USER PRIV_USER SCHEMA_US B FAILURES 46 REPADMIN REPADMIN REPADMIN N 6 Output from manual execution of job queue comisp2> execute dbms_job.run('46'); * Contents of SNPx process trace file *** SESSION ID:(9.121) 1997.03.05.22.20.06.000
----- ---------- ---------- ---------- - --------
WHAT
---------------------------------------------------------------------------
45 REPADMIN REPADMIN REPADMIN N 6
dbms_refresh.refresh('"REPADMIN"."MERCH"');
dbms_refresh.refresh('"REPADMIN"."INV"');
begin dbms_job.run('46'); end;
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 242
ORA-06512: at "SYS.DBMS_JOB", line 218
ORA-06512: at line 1
ORA-12012: error on auto execute of job 46
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 271
ORA-06512: at "SYS.DBMS_IREFRESH", line 413
ORA-06512: at "SYS.DBMS_REFRESH", line 171
ORA-06512: at line 1
Wed Mar 5 22:25:06 1997
Wed Mar 5 22:25:06 1997