JtheRipper
IS-IT--Management
Hi there,
I want to do a complete refresh of a MV in another user's schema. I have the following privileges granted to me:
When I execute the following command I get:
SQL> exec dbms_mview.refresh('ITEM_DIM','C');
BEGIN dbms_mview.refresh('ITEM_DIM','C'); END;
*
ERROR at line 1:
ORA-12018: following error encountered during code generation for
"ITEM_DIM"
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 832
ORA-06512: at line 1
Any ideas?
Thanks,
J.
I want to do a complete refresh of a MV in another user's schema. I have the following privileges granted to me:
Code:
DBA
CONNECT
DW_USER
DEV_USER
RESOURCE
ANALYZE ANY
CREATE TABLE
DROP ANY VIEW
CREATE SESSION
ALTER ANY INDEX
ALTER ANY TABLE
CREATE ANY VIEW
CREATE SNAPSHOT
CREATE ANY TABLE
SELECT ANY TABLE
DROP ANY SNAPSHOT
ALTER ANY SNAPSHOT
CREATE ANY SNAPSHOT
GLOBAL QUERY REWRITE
UNLIMITED TABLESPACE
PRIVILEGE
----------------------------------------
SELECT
REFERENCES
ALTER
When I execute the following command I get:
SQL> exec dbms_mview.refresh('ITEM_DIM','C');
BEGIN dbms_mview.refresh('ITEM_DIM','C'); END;
*
ERROR at line 1:
ORA-12018: following error encountered during code generation for
"ITEM_DIM"
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 832
ORA-06512: at line 1
Any ideas?
Thanks,
J.