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 will be available on generic Linux platforms in January and soon on AIX and Windows

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