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

VIEW: SYS.DBA_REPCAT_USER_AUTHORIZATIONS

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
REFRESH_TEMPLATE_NAME VARCHAR2 (30) Yes Name of the refresh group template.
OWNER VARCHAR2 (128) Yes Owner of the refresh group template.
REFRESH_GROUP_NAME VARCHAR2 (30) Yes Name of the refresh group to create during instantiation.
TEMPLATE_COMMENT VARCHAR2 (2000)
Optional comment field for the refresh group template.
PUBLIC_TEMPLATE VARCHAR2 (1)
Flag specifying public template or private template.
USER_NAME VARCHAR2 (128) Yes Database user name.
Query Text

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


SELECT REFRESH_TEMPLATE_NAME
,      OWNER
,      REFRESH_GROUP_NAME
,      TEMPLATE_COMMENT
,      PUBLIC_TEMPLATE
,      USER_NAME
FROM SYS.DBA_REPCAT_USER_AUTHORIZATIONS;

Dependencies

[top of page]

SYS.DBA_REPCAT_USER_AUTHORIZATIONS references the following:

SchemaSYS
ViewALL_USERS
SchemaSYSTEM
TableREPCAT$_REFRESH_TEMPLATES
TableREPCAT$_TEMPLATE_TYPES
TableREPCAT$_USER_AUTHORIZATIONS
SYS.DBA_REPCAT_USER_AUTHORIZATIONS is referenced by following:

SchemaPUBLIC
SynonymDBA_REPCAT_USER_AUTHORIZATIONS
SchemaSYS
Package BodyDBMS_REPCAT_RGT_CUST - show dependent code