Oracle | LBAC

Oracle LBAC_EXP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Label Security export utility

AUTHID CURRENT_USER

Dependencies

DBMS_ASSERT	DBMS_PRIV_CAPTURE	LBAC_SERVICES
DBMS_DATAPUMP	LBAC_CACHE	LBAC_STANDARD

Documented No

Exceptions

Error Code	Reason
`ORA-42909`	`cannot be executed outside datapump export`

First Available 12.2

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

Label Security instance export for internal use only lbac_exp.instance_info_exp( name IN VARCHAR2, schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       nb_out BINARY_INTEGER;

       retVal VARCHAR2(60);

      BEGIN

        retVal := lbac_exp.instance_info_exp('orabasex', 'C##SEC_ADMIN', 0, 1, '23.08.00', nb_out);

        dbms_output.put_line(TO_CHAR(nb_out));

        dbms_output.put_line(retVal);

      END;

      /

      ORA-42909: cannot be executed outside datapump export

SCHEMA_INFO_EXP

Label Security schema export for internal use only lbac_exp.schema_info_exp( schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       nb_out BINARY_INTEGER;

       retVal VARCHAR2(60);

      BEGIN

        retVal := lbac_exp.schema_info_exp('SCOTT', 0, 1, '23.08.00', nb_out);

        dbms_output.put_line(TO_CHAR(nb_out));

        dbms_output.put_line(retVal);

      END;

      /

      ORA-42909: cannot be executed outside datapump export

SYSTEM_INFO_EXP

Label Security system export for internal use only lbac_exp.system_info_exp( prepost IN BINARY_INTEGER, connectstring OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       cs_out VARCHAR2(60);

       nb_out BINARY_INTEGER;

       retVal VARCHAR2(60);

      BEGIN

        retVal := lbac_exp.system_info_exp(0, cs_out, '23.08.00', nb_out);

        dbms_output.put_line(cs_out);

        dbms_output.put_line(TO_CHAR(nb_out));

        dbms_output.put_line(retVal);

      END;

      /

      ORA-42909: cannot be executed outside datapump export