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 -> Re: Replication and insufficient privileges

Re: Replication and insufficient privileges

From: Steven H. Meller <smeller_at_nospam.com>
Date: Wed, 16 Dec 1998 08:24:30 -0500
Message-ID: <3677b2da.0@stnws02.atl.mediaone.net>


Privileges granted through roles do not pass through a stored procedure in certain situations. You must explicitly grant the permission to the user. I believe I recall seeing this in the server docs.

HTH,
Steve
Aric Rosenbaum wrote in message <3675443B.7B1A3009_at_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
>
Received on Wed Dec 16 1998 - 07:24:30 CST

Original text of this message

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