[Home] [Help] [Dependency Information]

TABLE: LBACSYS.OLS$USER_LEVELS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: OLS_USER_LEVEL_PK

1. POL#
2. USR_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
OLS_USER_LEVEL_PK	NORMAL	UNIQUE	SYSTEM	POL# USR_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
OLS$USER_LEVELS		OLS$LEVELS	OLS$USER_LEVELS POL# OLS$USER_LEVELS MIN_LEVEL
OLS$USER_LEVELS		OLS$LEVELS	OLS$USER_LEVELS POL# OLS$USER_LEVELS MAX_LEVEL
OLS$USER_LEVELS		OLS$LEVELS	OLS$USER_LEVELS POL# OLS$USER_LEVELS ROW_LEVEL
OLS$USER_LEVELS		OLS$LEVELS	OLS$USER_LEVELS POL# OLS$USER_LEVELS DEF_LEVEL
OLS$USER_LEVELS		OLS$POL	OLS$USER_LEVELS POL#
OLS$USER_COMPARTMENTS		OLS$USER_LEVELS	OLS$USER_COMPARTMENTS POL# OLS$USER_COMPARTMENTS USR_NAME
OLS$USER_GROUPS		OLS$USER_LEVELS	OLS$USER_GROUPS POL# OLS$USER_GROUPS USR_NAME

Columns

Query Text

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

SELECT POL#
,      USR_NAME
,      MAX_LEVEL
,      MIN_LEVEL
,      DEF_LEVEL
,      ROW_LEVEL
FROM LBACSYS.OLS$USER_LEVELS;

Dependencies

[top of page]

LBACSYS.OLS$USER_LEVELS does not reference any database object

LBACSYS.OLS$USER_LEVELS is referenced by following:

LBACSYS

ALL_SA_LEVELS

ALL_SA_USER_LEVELS

DBA_SA_USER_LEVELS

LBAC$SA_LABELS - show dependent code

OLS_DIP_NTFY - show dependent code

SA_SESSION - show dependent code

SA_USER_ADMIN - show dependent code