Re: Refresh group

It looks like i have to grant SELECT privilege to the schema/user that I want to do the query (whichever of those i use, or if I just use SYS.rgroup$ itself). I thought there would be an equivalent (like user_tables) in the sense that the scehma/user would natively have access to it.

thanks,

On Jan 31, 11:56 am, DA Morgan <damor..._at_psoug.org> wrote:
> Luch wrote:
> > Is there an equivlanent schema/user view to this view:
> > SELECT *
> > FROM SYS.rgroup$
> > ;
>
> > Just like there is SYS.ALL_TABLES and the equivalent USER_TABLES, I
> > want the user equivalent of RGROUP$, so i can see within the user if a
> > refresh group exists or not.
>
> SQL> select name from dba_dependencies
> 2 where referenced_name = 'RGROUP$'
> 3 and type = 'VIEW'
> 4 union
> 5 select referenced_name from dba_dependencies
> 6 where name = 'RGROUP$'
> 7 and type = 'VIEW';
>
> NAME
> -------------------------------------------------
> DBA_REFRESH
> DBA_REFRESH_CHILDREN
> DBA_RGROUP
> EXU81RGS
> KU$_ADD_SNAP_VIEW
> KU$_M_VIEW_VIEW
> KU$_REFGROUP_VIEW
>
> 7 rows selected.
>
> SQL>
>
> I'd look at the first three.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Wed Jan 31 2007 - 17:10:48 CST