VIEW: LBACSYS.ALL_SA_LEVELS

Source

View Text - Preformatted

SELECT p.pol_name as policy_name, l.level# AS level_num,
          l.code AS short_name, l.name AS long_name
     FROM LBACSYS.sa$pol p, LBACSYS.ols$levels l
    WHERE p.pol# = l.pol#
      AND p.pol# in (select pol# from LBACSYS.sa$admin where usr_name=user)
    UNION
   SELECT p.pol_name as policy_name, l.level# AS level_num,
          l.code AS short_name, l.name AS long_name
     FROM LBACSYS.sa$pol p, LBACSYS.ols$levels l, LBACSYS.ols$user_levels ul
    WHERE p.pol# = l.pol#
      and l.pol# = ul.pol#
      and l.level# <= ul.max_level
      and
      ul.usr_name = sa_session.sa_user_name(lbac_cache.policy_name(ul.pol#))

View Text - HTML Formatted

SELECT P.POL_NAME AS POLICY_NAME
, L.LEVEL# AS LEVEL_NUM
, L.CODE AS SHORT_NAME
, L.NAME AS LONG_NAME
FROM LBACSYS.SA$POL P
, LBACSYS.OLS$LEVELS L
WHERE P.POL# = L.POL#
AND P.POL# IN (SELECT POL#
FROM LBACSYS.SA$ADMIN
WHERE USR_NAME=USER) UNION SELECT P.POL_NAME AS POLICY_NAME
, L.LEVEL# AS LEVEL_NUM
, L.CODE AS SHORT_NAME
, L.NAME AS LONG_NAME
FROM LBACSYS.SA$POL P
, LBACSYS.OLS$LEVELS L
, LBACSYS.OLS$USER_LEVELS UL
WHERE P.POL# = L.POL#
AND L.POL# = UL.POL#
AND L.LEVEL# <= UL.MAX_LEVEL AND UL.USR_NAME = SA_SESSION.SA_USER_NAME(LBAC_CACHE.POLICY_NAME(UL.POL#))