[Home] [Help] [Dependency Information]

TABLE: LBACSYS.OLS$LEVELS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: OLS_LEVEL_PK

1. POL#
2. LEVEL#

Unique Key: OLS_LEVEL_LONG_UNIQUE

1. POL#
2. NAME

Unique Key: OLS_LEVEL_SHORT_UNIQUE

1. POL#
2. CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
OLS_LEVEL_LONG_UNIQUE	NORMAL	UNIQUE	SYSTEM	POL# NAME
OLS_LEVEL_PK	NORMAL	UNIQUE	SYSTEM	POL# LEVEL#
OLS_LEVEL_SHORT_UNIQUE	NORMAL	UNIQUE	SYSTEM	POL# CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
OLS$LEVELS		OLS$POL	OLS$LEVELS POL#
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$LEVELS	OLS$USER_LEVELS POL# OLS$USER_LEVELS MIN_LEVEL

Columns

Query Text

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

SELECT POL#
,      LEVEL#
,      CODE
,      NAME
FROM LBACSYS.OLS$LEVELS;

Dependencies

[top of page]

LBACSYS.OLS$LEVELS does not reference any database object

LBACSYS.OLS$LEVELS is referenced by following:

DVSYS

DBMS_MACOLS - show dependent code

LBACSYS

ALL_SA_LEVELS

ALL_SA_USER_LEVELS

DBA_SA_LEVELS

DBA_SA_USER_LEVELS

FEATURE_USAGE - show dependent code

LBAC$SA_LABELS - show dependent code

SA_COMPONENTS - show dependent code

SA_USER_ADMIN - show dependent code