From mkb125@yahoo.com Tue, 18 Sep 2001 12:48:23 -0700 From: mohammed bhatti Date: Tue, 18 Sep 2001 12:48:23 -0700 Subject: Re: Materialized View/dbms_mview.refresh Question Message-ID: MIME-Version: 1.0 Content-Type: text/plain Just solved it...Duh! as sys grant alter any materialized view to User_B; --- mohammed bhatti wrote: > 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@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@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). __________________________________________________ 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@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@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).