Re: Refresh group

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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org