Materialized View/dbms_mview.refresh Question

From: mohammed bhatti <mkb125_at_yahoo.com>
Date: Tue, 18 Sep 2001 10:48:54 -0700
Message-ID: <F001.00391A8C.20010918094017@fatcity.com>

I have a materialized view created by user A in schema A. The view consists of simple table joins and union statements. I want user B to be able to execute the refresh on the MV using dbms_mview.refresh.

I've granted select on all the tables to user B along with creating public synonyms for the tables. I've also granted all privileges on the MV to user B and granted REWRITE privs to user B.

When I exec dbms_mview.refresh('A.MVIEW_NAME', 'A'); as user B, I get the following error:

ORA-01031: Insufficent privileges
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 610
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 667
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 647
ORA-06512: at line 1

Any thoughts?

Thanks

---

Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: mohammed bhatti
  INET: mkb125_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 18 2001 - 12:48:54 CDT