Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Replication and insufficient privileges
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