VIEW: LBACSYS.DBA_LBAC_LABELS

Source

View Text - Preformatted

SELECT pol_name AS policy_name,
         slabel AS label,
         nlabel AS label_tag,
         DECODE (l.flags,2,'USER LABEL',
                 3, 'USER/DATA LABEL', 'UNDEFINED') AS label_type
  FROM LBACSYS.ols$lab l, LBACSYS.ols$pol p
  WHERE p.pol# = l.pol#

View Text - HTML Formatted

SELECT POL_NAME AS POLICY_NAME
, SLABEL AS LABEL
, NLABEL AS LABEL_TAG
, DECODE (L.FLAGS
, 2
, 'USER LABEL'
, 3
, 'USER/DATA LABEL'
, 'UNDEFINED') AS LABEL_TYPE
FROM LBACSYS.OLS$LAB L
, LBACSYS.OLS$POL P
WHERE P.POL# = L.POL#