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: LBACSYS.OLS$USER_COMPARTMENTS

Object Details

Object Name:	OLS$USER_COMPARTMENTS
Object Type:	TABLE
Owner:	LBACSYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: OLS_USER_COMP_PK

POL#
USR_NAME
COMP#

Indexes

Index	Type	Uniqueness	Tablespace	Column
OLS_USER_COMP_PK	NORMAL	UNIQUE	SYSTEM	POL# USR_NAME COMP#

Foreign Keys

Table		Foreign Table	Foreign Key Column
OLS$USER_COMPARTMENTS		OLS$COMPARTMENTS	OLS$USER_COMPARTMENTS POL# OLS$USER_COMPARTMENTS COMP#
OLS$USER_COMPARTMENTS		OLS$USER_LEVELS	OLS$USER_COMPARTMENTS POL# OLS$USER_COMPARTMENTS USR_NAME

Columns

Name	Datatype	Length	Mandatory
POL#	NUMBER		Yes
USR_NAME	VARCHAR2	(1024)	Yes
COMP#	NUMBER	(4)	Yes
RW_ACCESS	NUMBER	(2)	Yes
DEF_COMP	VARCHAR2	(1)	Yes
ROW_COMP	VARCHAR2	(1)	Yes

Query Text

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


SELECT POL#
,      USR_NAME
,      COMP#
,      RW_ACCESS
,      DEF_COMP
,      ROW_COMP
FROM LBACSYS.OLS$USER_COMPARTMENTS;

Dependencies

[top of page]

LBACSYS.OLS$USER_COMPARTMENTS does not reference any database object

LBACSYS.OLS$USER_COMPARTMENTS is referenced by following:

LBACSYS: ALL_SA_COMPARTMENTS; ALL_SA_USER_COMPARTMENTS; DBA_SA_USER_COMPARTMENTS; LBAC$SA_LABELS - show dependent code; SA_USER_ADMIN - show dependent code