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$POL

Object Details

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

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00279060

POL#

Unique Key: SYS_C00279061

POL_NAME

Unique Key: SYS_C00279062

COLUMN_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00279060	NORMAL	UNIQUE	SYSTEM	POL#
SYS_C00279061	NORMAL	UNIQUE	SYSTEM	POL_NAME
SYS_C00279062	NORMAL	UNIQUE	SYSTEM	COLUMN_NAME
OLS$POL_PFCPIDX	NORMAL	NONUNIQUE	SYSTEM	POL# FLAGS COLUMN_NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
OLS$AUDIT	OLS$POL	OLS$AUDIT POL#
OLS$COMPARTMENTS	OLS$POL	OLS$COMPARTMENTS POL#
OLS$GROUPS	OLS$POL	OLS$GROUPS POL#
OLS$LAB	OLS$POL	OLS$LAB POL#
OLS$LEVELS	OLS$POL	OLS$LEVELS POL#
OLS$POLICY_ADMIN	OLS$POL	OLS$POLICY_ADMIN POLICY_NAME
OLS$POLS	OLS$POL	OLS$POLS POL#
OLS$POLT	OLS$POL	OLS$POLT POL#
OLS$PROFILE	OLS$POL	OLS$PROFILE POL#
OLS$PROFILES	OLS$POL	OLS$PROFILES POLICY_NAME
OLS$PROG	OLS$POL	OLS$PROG POL#
OLS$USER	OLS$POL	OLS$USER POL#
OLS$USER_LEVELS	OLS$POL	OLS$USER_LEVELS POL#

Columns

Name	Datatype	Length	Mandatory
POL#	NUMBER		Yes
POL_NAME	VARCHAR2	(30)	Yes
COLUMN_NAME	VARCHAR2	(128)	Yes
PACKAGE	VARCHAR2	(30)	Yes
POL_ROLE	VARCHAR2	(30)	Yes
OPTIONS	NUMBER
FLAGS	NUMBER		Yes

Query Text

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


SELECT POL#
,      POL_NAME
,      COLUMN_NAME
,      PACKAGE
,      POL_ROLE
,      OPTIONS
,      FLAGS
FROM LBACSYS.OLS$POL;

Dependencies

[top of page]

LBACSYS.OLS$POL does not reference any database object

LBACSYS.OLS$POL is referenced by following:

DVSYS: DBA_DV_MAC_POLICY; DBA_DV_MAC_POLICY_FACTOR; DBA_DV_POLICY_LABEL; DBMS_MACOLS - show dependent code; DBMS_MACOLS_SESSION - show dependent code; DBMS_MACSEC - show dependent code; DV$MAC_POLICY; DV$MAC_POLICY_FACTOR; DV$OLS_POLICY; DV$OLS_POLICY_LABEL; DV$POLICY_LABEL
LBACSYS: DBA_LBAC_DATA_LABELS; DBA_LBAC_LABELS; DBA_LBAC_LABEL_TAGS; DBA_LBAC_POLICIES; DBA_LBAC_SCHEMA_POLICIES; DBA_LBAC_TABLE_POLICIES; DBA_OLS_AUDIT_OPTIONS; DBA_OLS_USERS; DBA_SA_COMPARTMENTS; DBA_SA_GROUPS; DBA_SA_GROUP_HIERARCHY; DBA_SA_LABELS; DBA_SA_LEVELS; DBA_SA_PROGRAMS; DBA_SA_PROG_PRIVS; DBA_SA_USER_COMPARTMENTS; DBA_SA_USER_GROUPS; DBA_SA_USER_LEVELS; LBAC$SA - show dependent code; LBAC$SA_LABELS - show dependent code; LBAC_POLICY_ADMIN - show dependent code; LBAC_SYSDBA - show dependent code; LBAC_UTL - show dependent code; OLS$DATAPUMP - show dependent code; OLS$TRUSTED_PROGS; SA$ADMIN; SA$POL; SA_AUDIT_ADMIN - show dependent code; SA_SESSION - show dependent code; SA_USER_ADMIN - show dependent code; USER_SA_SESSION