VIEW: LBACSYS.ALL_SA_USER_GROUPS

Source

View Text - Preformatted

SELECT p.pol_name AS policy_name, ug.usr_name AS user_name,
          g.code AS grp, DECODE(ug.rw_access,'1','WRITE','READ') AS rw_access,
          ug.def_group, ug.row_group
     FROM LBACSYS.sa$pol p, LBACSYS.ols$user_groups ug, LBACSYS.ols$groups g
    WHERE p.pol#=ug.pol#
      AND ug.pol#=g.pol#
      AND ug.group# = g.group#
      AND (p.pol# in (select pol# from LBACSYS.sa$admin where usr_name=user)
           or
           ug.usr_name = sa_session.sa_user_name(lbac_cache.policy_name(p.pol#)))

View Text - HTML Formatted

SELECT P.POL_NAME AS POLICY_NAME
, UG.USR_NAME AS USER_NAME
, G.CODE AS GRP
, DECODE(UG.RW_ACCESS
, '1'
, 'WRITE'
, 'READ') AS RW_ACCESS
, UG.DEF_GROUP
, UG.ROW_GROUP
FROM LBACSYS.SA$POL P
, LBACSYS.OLS$USER_GROUPS UG
, LBACSYS.OLS$GROUPS G
WHERE P.POL#=UG.POL#
AND UG.POL#=G.POL#
AND UG.GROUP# = G.GROUP#
AND (P.POL# IN (SELECT POL#
FROM LBACSYS.SA$ADMIN
WHERE USR_NAME=USER) OR UG.USR_NAME = SA_SESSION.SA_USER_NAME(LBAC_CACHE.POLICY_NAME(P.POL#)))