Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Refresh group
On Jan 31, 6:58 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Luch wrote:
> > 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,
>
> Two things.
>
> First ... don't top post. Scroll to the bottom to reply.
>
> Second ... use some imagination. ;-)
>
> Where there is dba_ ... there is almost always all_ and user_
>
> SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jan 31 15:53:11 2007
>
> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> desc user_refresh
> Name Null? Type
> ----------------------------------------- -------- ----------------------
> ROWNER NOT NULL VARCHAR2(30)
> RNAME NOT NULL VARCHAR2(30)
> REFGROUP NUMBER
> IMPLICIT_DESTROY VARCHAR2(1)
> PUSH_DEFERRED_RPC VARCHAR2(1)
> REFRESH_AFTER_ERRORS VARCHAR2(1)
> ROLLBACK_SEG VARCHAR2(30)
> JOB NUMBER
> NEXT_DATE DATE
> INTERVAL VARCHAR2(200)
> BROKEN VARCHAR2(1)
> PURGE_OPTION NUMBER(38)
> PARALLELISM NUMBER(38)
> HEAP_SIZE NUMBER(38)
>
> SQL> desc all_refresh
> Name Null? Type
> ----------------------------------------- -------- ----------------------
> ROWNER NOT NULL VARCHAR2(30)
> RNAME NOT NULL VARCHAR2(30)
> REFGROUP NUMBER
> IMPLICIT_DESTROY VARCHAR2(1)
> PUSH_DEFERRED_RPC VARCHAR2(1)
> REFRESH_AFTER_ERRORS VARCHAR2(1)
> ROLLBACK_SEG VARCHAR2(30)
> JOB NUMBER
> NEXT_DATE DATE
> INTERVAL VARCHAR2(200)
> BROKEN VARCHAR2(1)
> PURGE_OPTION NUMBER(38)
> PARALLELISM NUMBER(38)
> HEAP_SIZE NUMBER(38)
>
> SQL> desc dba_refresh
> Name Null? Type
> ----------------------------------------- -------- ----------------------
> ROWNER NOT NULL VARCHAR2(30)
> RNAME NOT NULL VARCHAR2(30)
> REFGROUP NUMBER
> IMPLICIT_DESTROY VARCHAR2(1)
> PUSH_DEFERRED_RPC VARCHAR2(1)
> REFRESH_AFTER_ERRORS VARCHAR2(1)
> ROLLBACK_SEG VARCHAR2(30)
> JOB NUMBER
> NEXT_DATE DATE
> INTERVAL VARCHAR2(200)
> BROKEN VARCHAR2(1)
> PURGE_OPTION NUMBER(38)
> PARALLELISM NUMBER(38)
> HEAP_SIZE NUMBER(38)
>
> SQL>
>
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Ah yes... I did try finding the user equivalent to RGROUP$, but I should've tried again with the other views you showed me... thanks again, now I don't have to worry about doing the grant. Received on Thu Feb 01 2007 - 10:32:09 CST