DBA Data[Home] [Help] [Dependency Information]

TABLE: SYSTEM.REPCAT$_REPGROUP_PRIVS

Object Details
Object Name: REPCAT$_REPGROUP_PRIVS
Object Type: TABLE
Owner: SYSTEM
Subobject Name:
Status: VALID

Information about users who are registered for object group privileges

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Unique Key: REPCAT$_REPGROUP_PRIVS_UK
  1. ColumnUSERNAME
  2. ColumnGNAME
  3. ColumnGOWNER
Indexes
Index Type Uniqueness Tablespace Column
REPCAT$_REPGROUP_PRIVS_UK NORMAL UNIQUE TablespaceSYSTEM ColumnUSERNAME
ColumnGNAME
ColumnGOWNER
REPCAT$_REPGROUP_PRIVS_FK_IDX NORMAL NONUNIQUE TablespaceSYSTEM ColumnGNAME
ColumnGOWNER
REPCAT$_REPGROUP_PRIVS_N1 NORMAL NONUNIQUE TablespaceSYSTEM ColumnGLOBAL_FLAG
ColumnUSERNAME
Foreign Keys
Table
Foreign Table Foreign Key Column
REPCAT$_REPGROUP_PRIVS REPCAT$_REPGROUP_PRIVS_FK TableREPCAT$_REPCAT REPCAT$_REPGROUP_PRIVS GNAME
REPCAT$_REPGROUP_PRIVS GOWNER
Columns
Name Datatype Length Mandatory Comments
USERID NUMBER

OBSOLETE COLUMN: Identifying number of the user
GOWNER VARCHAR2 (128)
Owner of the replicated object group
GNAME VARCHAR2 (30)
Name of the replicated object group
GLOBAL_FLAG NUMBER
Yes 1 if gname is NULL, 0 otherwise
CREATED DATE
Yes Registration date
PRIVILEGE NUMBER

Registered privileges
USERNAME VARCHAR2 (128) Yes Identifying name of the registered user
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USERID
,      GOWNER
,      GNAME
,      GLOBAL_FLAG
,      CREATED
,      PRIVILEGE
,      USERNAME
FROM SYSTEM.REPCAT$_REPGROUP_PRIVS;

Dependencies

[top of page]

SYSTEM.REPCAT$_REPGROUP_PRIVS does not reference any database object

SYSTEM.REPCAT$_REPGROUP_PRIVS is referenced by following:

SchemaSYS
ViewALL_REPGROUP_PRIVILEGES
ViewDBA_REPGROUP_PRIVILEGES
Package BodyDBMS_REPCAT_ADMIN - show dependent code
Package BodyDBMS_REPCAT_MIG_INTERNAL - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
ViewUSER_REPGROUP_PRIVILEGES