Oracle | SA_LABEL

Oracle LBAC_SESSION Version 21c

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 Label Security Undocumented Utilities

AUTHID DEFINER

Dependencies

LBAC$USER_LIBT

LBAC_CACHE

OLS$POL

Documented No

Exceptions

Error Code	Reason
ORA-12458	Oracle Label Security not enabled

First Available 10.1

Security Model Owned by LBACSYS with EXECUTE granted to PUBLIC

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

Subprograms

Undocumented lbac_session.bypassAll(policy_name IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF lbac_session.bypassAll('UW_LBAC_POLICY') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

BYPASS_READ

Undocumented lbac_session.bypassread(policy_name IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF lbac_session.bypassRead('UW_LBAC_POLICY') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

POLICY_DISABLED

Undocumented lbac_session.policy_disabled(policy_name IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF lbac_session.policy_disabled('UW_LBAC_POLICY') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx