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_GROUPS

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: OLS_USER_GRP_PK

POL#
USR_NAME
GROUP#

Indexes

Index	Type	Uniqueness	Tablespace	Column
OLS_USER_GRP_PK	NORMAL	UNIQUE	SYSTEM	POL# USR_NAME GROUP#

Foreign Keys

Table		Foreign Table	Foreign Key Column
OLS$USER_GROUPS		OLS$GROUPS	OLS$USER_GROUPS POL# OLS$USER_GROUPS GROUP#
OLS$USER_GROUPS		OLS$USER_LEVELS	OLS$USER_GROUPS POL# OLS$USER_GROUPS USR_NAME

Columns

Name	Datatype	Length	Mandatory
POL#	NUMBER		Yes
USR_NAME	VARCHAR2	(1024)	Yes
GROUP#	NUMBER	(4)	Yes
RW_ACCESS	NUMBER	(2)	Yes
DEF_GROUP	VARCHAR2	(1)	Yes
ROW_GROUP	VARCHAR2	(1)	Yes

Query Text

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


SELECT POL#
,      USR_NAME
,      GROUP#
,      RW_ACCESS
,      DEF_GROUP
,      ROW_GROUP
FROM LBACSYS.OLS$USER_GROUPS;

Dependencies

[top of page]

LBACSYS.OLS$USER_GROUPS does not reference any database object

LBACSYS.OLS$USER_GROUPS is referenced by following:

LBACSYS: ALL_SA_GROUPS; ALL_SA_GROUP_HIERARCHY; ALL_SA_USER_GROUPS; DBA_SA_USER_GROUPS; LBAC$SA_LABELS - show dependent code; SA_USER_ADMIN - show dependent code