Re: dbms_mview.refresh question

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Sat, 30 Jun 2001 16:22:34 -0000
Message-ID: <tjsgoracs57c62@corp.supernews.com>

You may need tro grant execute to the procedure directly to the user and not throgh a role.

Also does the user have access granted to the materialized view?

Hope this helps

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Rob K" <robkato_at_earthlink.net> wrote in message news:SF0%6.3331$ck5.359136_at_newsread2.prod.itd.earthlink.net...
> I have a procedure in dwp1 schema that executes
> the dbms_mview.refresh procedure.
> If I grant execute on that procedure and run the procedure from another
user
> I get the following errors.
>
> SQL> exec mview_refresh
> BEGIN mview_refresh; END;
>
> *
> ERROR at line 1:
> ORA-01403: no data found
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1046
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 1028
> ORA-06512: at "DWP1.MVIEW_REFRESH", line 10
> ORA-06512: at line 1
>
> I don't get any errors if I run it under the dwp1 schema.
>
> Thanks Rob
>
>
Received on Sat Jun 30 2001 - 11:22:34 CDT