DBSecWorx: TO_LABEL

Oracle TO_LABEL_LIST Version 21c

General Information

Library Note

Purpose Undocumented

AUTHID DEFINER

Dependencies

LBAC_CACHE	LBAC_LABEL_LIST	LBAC_STANDARD
LBAC_LABEL

Documented No

First Available 10.1

Security Model Owned by LBACSYS with no privileges granted.

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

FROM_LABEL

Undocumented to_label_list.from_label( polic IN BINARY_INTEGER, label1 IN XMLTYPE, label2 IN XMLTYPE DEFAULT NULL, label3 IN XMLTYPE DEFAULT NULL, label4 IN XMLTYPE DEFAULT NULL, label5 IN XMLTYPE DEFAULT NULL, label6 IN XMLTYPE DEFAULT NULL) RETURN XMLTYPE;

No working demo but appears to be related to the following view and its underlying tables.

      

      CREATE OR REPLACE FORCE NONEDITIONABLE VIEW "LBACSYS"."DBA_OLS_USERS"

      ("USER_NAME", "POLICY_NAME", "USER_PRIVILEGES", "LABEL1", "LABEL2", "LABEL3", "LABEL4",

      "LABEL5", "LABEL6") AS

      SELECT usr_name AS user_name,

             pol_name AS policy_name,

             lbacsys.privs_to_char_n(pf.privs) AS user_privileges,

             lbacsys.lbac$sa_labels.from_label(pf.max_read)  AS LABEL1,

             lbacsys.lbac$sa_labels.from_label(pf.max_write) AS LABEL2,

             lbacsys.lbac$sa_labels.from_label(pf.min_write) AS LABEL3,

             lbacsys.lbac$sa_labels.from_label(pf.def_read)  AS LABEL4,

             lbacsys.lbac$sa_labels.from_label(pf.def_write) AS LABEL5,

             lbacsys.lbac$sa_labels.from_label(pf.def_row)   AS LABEL6

      FROM LBACSYS.ols$pol p, LBACSYS.ols$user u, LBACSYS.ols$profile pf

      WHERE p.pol# = u.pol#

      AND p.pol# = pf.pol#

      AND u.pol# = pf.pol#

      AND u.profid = pf.profid