Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Replication and insufficient privileges

Replication and insufficient privileges

From: Aric Rosenbaum <aricr_at_arconsultinginc.com>
Date: Mon, 14 Dec 1998 12:00:43 -0500
Message-ID: <3675443B.7B1A3009@arconsultinginc.com>


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.

Received on Mon Dec 14 1998 - 11:00:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US