Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Replication and insufficient privileges
We are trying to set up replication between two instances. Read only
works OK. However, updateable snapshots are failing. The trace on the
slave site shows:
Errors in file C:\ORANT\RDBMS73\trace\hkSNP0.TRC:
ORA-12012: error on auto execute of job 41 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
The snapshot groups were created by REPADMIN which was created via:
CREATE USER repadmin IDENTIFIED BY repadmin; EXECUTE dbms_repcat_admin.grant_admin_any_repgroup(userid=>'repadmin'); GRANT EXECUTE ON dbms_defer TO repadmin WITH GRANT OPTION;
In addition, if I manually run the job, it fails. However, if I manually run the contents of the job (i.e. execute dbms_refresh(...), it works.
Thanks in advance.