[Home] [Help] [Dependency Information]

TABLE: LBACSYS.OLS$GROUPS

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: OLS_GROUP_PK

1. POL#
2. GROUP#

Unique Key: OLS_GROUP_LONG_UNIQUE

1. POL#
2. NAME

Unique Key: OLS_GROUP_SHORT_UNIQUE

1. POL#
2. CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
OLS_GROUP_LONG_UNIQUE	NORMAL	UNIQUE	SYSTEM	POL# NAME
OLS_GROUP_PK	NORMAL	UNIQUE	SYSTEM	POL# GROUP#
OLS_GROUP_SHORT_UNIQUE	NORMAL	UNIQUE	SYSTEM	POL# CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
OLS$GROUPS		OLS$GROUPS	OLS$GROUPS POL# OLS$GROUPS PARENT#
OLS$GROUPS		OLS$POL	OLS$GROUPS POL#
OLS$GROUPS		OLS$GROUPS	OLS$GROUPS POL# OLS$GROUPS PARENT#
OLS$USER_GROUPS		OLS$GROUPS	OLS$USER_GROUPS POL# OLS$USER_GROUPS GROUP#

Columns

Query Text

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

SELECT POL#
,      GROUP#
,      CODE
,      NAME
,      PARENT#
FROM LBACSYS.OLS$GROUPS;

Dependencies

[top of page]

LBACSYS.OLS$GROUPS does not reference any database object

LBACSYS.OLS$GROUPS is referenced by following:

LBACSYS

ALL_SA_GROUPS

ALL_SA_GROUP_HIERARCHY

ALL_SA_USER_GROUPS

DBA_SA_GROUPS

DBA_SA_GROUP_HIERARCHY

DBA_SA_USER_GROUPS

FEATURE_USAGE - show dependent code

LBAC$SA_LABELS - show dependent code

SA_COMPONENTS - show dependent code

SA_USER_ADMIN - show dependent code