Oracle: SA_LABEL

Oracle LBAC_SESSION Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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