VIEW: LBACSYS.ALL_SA_LABELS

Source

View Text - Preformatted

SELECT p.pol_name AS policy_name,
         l.slabel   AS label,
         l.nlabel   AS label_tag,
         DECODE (l.flags,2,'USER LABEL',
                 3, 'USER/DATA LABEL', 'UNDEFINED') AS label_type
   FROM LBACSYS.ols$lab l, LBACSYS.sa$pol p
  WHERE p.pol# = l.pol#
    AND (p.pol# in (select pol# from LBACSYS.sa$admin where usr_name=user)
         OR
         LBACSYS.lbac$sa.enforce_read(p.pol_name, l.ilabel)>0)

View Text - HTML Formatted

SELECT P.POL_NAME AS POLICY_NAME
, L.SLABEL AS LABEL
, L.NLABEL AS LABEL_TAG
, DECODE (L.FLAGS
, 2
, 'USER LABEL'
, 3
, 'USER/DATA LABEL'
, 'UNDEFINED') AS LABEL_TYPE
FROM LBACSYS.OLS$LAB L
, LBACSYS.SA$POL P
WHERE P.POL# = L.POL#
AND (P.POL# IN (SELECT POL#
FROM LBACSYS.SA$ADMIN
WHERE USR_NAME=USER) OR LBACSYS.LBAC$SA.ENFORCE_READ(P.POL_NAME
, L.ILABEL)>0)