Oracle | OLS_UTIL

Oracle OLS_UTIL_WRAPPER Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented Oracle Label Security Utilities

AUTHID DEFINER

Data Types sys.ku$_status Name Type ------------------------ ------------------ MASK NUMBER WIP KU$_LOGENTRY1010 JOB_DESCRIPTION KU$_JOBDESC1220 JOB_STATUS KU$_JOBSTATUS1220 ERROR KU$_LOGENTRY1010

Dependencies

DBMS_ASSERT	KU$_STATUS	OLS$DATAPUMP
DBMS_DATAPUMP	LBAC_SYSDBA

Documented No

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to LBACSYS

Source {ORACLE_HOME}/rdbms/admin/prvtolsdd.plb

Subprograms

Create Label Security Temp Table

Protected by an ACCESIBLE BY clause ols_util_wrapper.create_temp_table;

exec ols_util_wrapper.create_temp_table;

           *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object OLS_UTIL_WRAPPER

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

DROP_ROLE

Drop Label Security Role

Protected by an ACCESIBLE BY clause ols_util_wrapper.drop_role(prole IN VARCHAR2);

exec ols_util_wrapper.drop_role('ZZYZX');

           *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object OLS_UTIL_WRAPPER

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

GET_STATUS

Undocumented ols_util_wrapper.get_status( handle IN NUMBER, mask IN NUMBER, timeout IN NUMBER) RETURN ku$_status;

TBD

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx