DBA Data[Home] [Help] [Dependency Information]


TABLE: LBACSYS.OLS$AUDIT

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

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: SYS_C00279168
  1. ColumnPOL#
  2. ColumnUSR_NAME
Indexes
Index Type Uniqueness Tablespace Column
SYS_C00279168 NORMAL UNIQUE TablespaceSYSTEM ColumnPOL#
ColumnUSR_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
OLS$AUDIT SYS_C00279169 TableOLS$POL OLS$AUDIT POL#
Columns
Name Datatype Length Mandatory Comments
POL# NUMBER
Yes
USR_NAME VARCHAR2 (128) Yes
OPTION# NUMBER

SUCCESS NUMBER

FAILURE NUMBER

SUC_TYPE NUMBER

FAIL_TYPE NUMBER

OPTION_PRIV# NUMBER

SUCCESS_PRIV NUMBER

FAILURE_PRIV NUMBER

SUC_PRIV_TYPE NUMBER

FAIL_PRIV_TYPE NUMBER

Query Text

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


SELECT POL#
,      USR_NAME
,      OPTION#
,      SUCCESS
,      FAILURE
,      SUC_TYPE
,      FAIL_TYPE
,      OPTION_PRIV#
,      SUCCESS_PRIV
,      FAILURE_PRIV
,      SUC_PRIV_TYPE
,      FAIL_PRIV_TYPE
FROM LBACSYS.OLS$AUDIT;

Dependencies

[top of page]

LBACSYS.OLS$AUDIT does not reference any database object

LBACSYS.OLS$AUDIT is referenced by following:

SchemaLBACSYS
ViewDBA_OLS_AUDIT_OPTIONS