VIEW: LBACSYS.ALL_SA_COMPARTMENTS

Source

View Text - Preformatted

SELECT p.pol_name as policy_name, c.comp# AS comp_num,
          c.code AS short_name, c.name AS long_name
     FROM LBACSYS.sa$pol p, LBACSYS.ols$compartments c
    WHERE p.pol# = c.pol#
      and (p.pol# in (select pol# from LBACSYS.sa$admin where usr_name=user)
           OR
          (c.pol#,c.comp#) in (select pol#,comp#
                               from LBACSYS.ols$user_compartments
                               where usr_name = sa_session.sa_user_name(
                                             lbac_cache.policy_name(pol#))))

View Text - HTML Formatted

SELECT P.POL_NAME AS POLICY_NAME
, C.COMP# AS COMP_NUM
, C.CODE AS SHORT_NAME
, C.NAME AS LONG_NAME
FROM LBACSYS.SA$POL P
, LBACSYS.OLS$COMPARTMENTS C
WHERE P.POL# = C.POL#
AND (P.POL# IN (SELECT POL#
FROM LBACSYS.SA$ADMIN
WHERE USR_NAME=USER) OR (C.POL#
, C.COMP#) IN (SELECT POL#
, COMP#
FROM LBACSYS.OLS$USER_COMPARTMENTS
WHERE USR_NAME = SA_SESSION.SA_USER_NAME( LBAC_CACHE.POLICY_NAME(POL#))))