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

VIEW: SYS.DBA_REPGROUP_PRIVILEGES

Object Details
Object Name: DBA_REPGROUP_PRIVILEGES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about users who are registered for object group privileges

[View Source]

Columns
Name Datatype Length Mandatory Comments
USERNAME VARCHAR2 (128) Yes Name of the user
GNAME VARCHAR2 (30)
Name of the replicated object group
CREATED DATE
Yes Registration date
RECEIVER VARCHAR2 (1)
Receiver privileges
PROXY_SNAPADMIN VARCHAR2 (1)
Proxy snapadmin privileges
OWNER VARCHAR2 (128)
Owner of the replicated object group
Query Text

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


SELECT USERNAME
,      GNAME
,      CREATED
,      RECEIVER
,      PROXY_SNAPADMIN
,      OWNER
FROM SYS.DBA_REPGROUP_PRIVILEGES;

Dependencies

[top of page]

SYS.DBA_REPGROUP_PRIVILEGES references the following:

SchemaSYS
ViewDBA_USERS
SchemaSYSTEM
TableREPCAT$_REPGROUP_PRIVS
SYS.DBA_REPGROUP_PRIVILEGES is referenced by following:

SchemaPUBLIC
SynonymDBA_REPGROUP_PRIVILEGES
SchemaSYS
Package BodyDBMSOBJG - show dependent code
Package BodyDBMS_REPCAT_ADMIN - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
Package BodyDBMS_REPCAT_UTL3 - show dependent code