Oracle | OLS$DATAPUMP

Oracle OLS$DATAPUMP 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 Internal DataPump support package for Oracle Label Security (OLS)

AUTHID DEFINER

Dependencies

ALL_TABLES	KU$_STATUS	LBAC_PRIVS
DBMS_ASSERT	KU$_STATUS1220	OLS$POL
DBMS_DATAPUMP	LBAC_CACHE	OLS_UTIL_WRAPPER
DP_ADD_RLS_POLICY	LBAC_LABEL	PLITBLM
DP_DROP_RLS_POLICY	LBAC_LABEL_LIST	PRIVS_TO_CHAR
KU$_JOBDESC1220

Documented No

First Available 10.1

Security Model Owned by LBACSYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

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

Subprograms

INSTANCE_CALLOUT_IMP

SYSTEM_CALLOUT_IMP

INSTANCE_CALLOUT_IMP

Undocumented ols$datapump.instace_callout_imp( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, prepost IN BINARY_INTEGER, action OUT VARCHAR2, alt_name OUT VARCHAR2);

conn sys@pdbdev as sysdba

      

      CREATE TABLE test (

      testcol DATE);

      

      SELECT type#

      FROM obj$

      WHERE name = 'TEST';

      

      DECLARE

       actout   v$session.action%TYPE;

       anameout obj$.name%TYPE;

      BEGIN

        lbacsys.ols$datapump.instance_callout_imp('TEST', 'SYS', 2, 0, actout, anameout);

        dbms_output.put_line('Action: ' || actout);

        dbms_output.put_line('Name: ' || anameout);

      END;

      /

SYSTEM_CALLOUT_IMP

Undocumented ols$datapump.system_callout_imp(prepost IN BINARY_INTEGER);

exec lbacsys.ols$datapump.system_callout_imp(1);

      

      PL/SQL procedure successfully completed.