eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYSTEM.REPCAT$_USER_AUTHORIZATIONS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: REPCAT$_USER_AUTHORIZATIONS_PK

USER_AUTHORIZATION_ID

Unique Key: REPCAT$_USER_AUTHORIZATIONS_U1

USER_ID
REFRESH_TEMPLATE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
REPCAT$_USER_AUTHORIZATIONS_PK	NORMAL	UNIQUE	SYSTEM	USER_AUTHORIZATION_ID
REPCAT$_USER_AUTHORIZATIONS_U1	NORMAL	UNIQUE	SYSTEM	USER_ID REFRESH_TEMPLATE_ID
REPCAT$_USER_AUTHORIZATIONS_N1	NORMAL	NONUNIQUE	SYSTEM	REFRESH_TEMPLATE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
REPCAT$_USER_AUTHORIZATIONS		REPCAT$_REFRESH_TEMPLATES	REPCAT$_USER_AUTHORIZATIONS REFRESH_TEMPLATE_ID

Columns

Name	Datatype	Mandatory	Comments
USER_AUTHORIZATION_ID	NUMBER	Yes	Internal primary key of the REPCAT$_USER_AUTHORIZATIONS table.
USER_ID	NUMBER	Yes	Database user id.
REFRESH_TEMPLATE_ID	NUMBER	Yes	Internal primary key of the REPCAT$_REFRESH_TEMPLATES table.

Query Text

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


SELECT USER_AUTHORIZATION_ID
,      USER_ID
,      REFRESH_TEMPLATE_ID
FROM SYSTEM.REPCAT$_USER_AUTHORIZATIONS;

Dependencies

[top of page]

SYSTEM.REPCAT$_USER_AUTHORIZATIONS does not reference any database object

SYSTEM.REPCAT$_USER_AUTHORIZATIONS is referenced by following:

SYS: ALL_REPCAT_REFRESH_TEMPLATES; ALL_REPCAT_TEMPLATE_OBJECTS; ALL_REPCAT_TEMPLATE_PARMS; ALL_REPCAT_TEMPLATE_SITES; ALL_REPCAT_USER_AUTHORIZATIONS; ALL_REPCAT_USER_PARM_VALUES; DBA_REPCAT_USER_AUTHORIZATIONS; DBMS_REPCAT_RGT_ALT - show dependent code; DBMS_REPCAT_RGT_CHK - show dependent code; DBMS_REPCAT_RGT_CUST - show dependent code; DBMS_REPCAT_RGT_UTL - show dependent code; USER_REPCAT_REFRESH_TEMPLATES; USER_REPCAT_TEMPLATE_OBJECTS; USER_REPCAT_TEMPLATE_PARMS; USER_REPCAT_TEMPLATE_SITES; USER_REPCAT_USER_AUTHORIZATION; USER_REPCAT_USER_PARM_VALUES