eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: LBACSYS.DBA_SA_USER_LEVELS

Source

View Text - Preformatted


SELECT DISTINCT p.pol_name AS policy_name,
          ul.usr_name AS user_name,
          lmax.code AS max_level,
          lmin.code AS min_level,
          ldef.code AS def_level,
          lrow.code AS row_level
   FROM LBACSYS.ols$pol p, LBACSYS.ols$user_levels ul,
        LBACSYS.ols$levels lmax, LBACSYS.ols$levels lmin,
        LBACSYS.ols$levels ldef, LBACSYS.ols$levels lrow
   WHERE p.pol#=ul.pol# AND
         ul.pol#=lmax.pol# AND
         ul.pol#=lmin.pol# AND
         ul.pol#=ldef.pol# AND
         ul.pol#=lrow.pol# AND
         ul.max_level = lmax.level# AND
         ul.min_level = lmin.level# AND
         ul.def_level = ldef.level# AND
         ul.row_level = lrow.level#

View Text - HTML Formatted

SELECT DISTINCT P.POL_NAME AS POLICY_NAME
, UL.USR_NAME AS USER_NAME
, LMAX.CODE AS MAX_LEVEL
, LMIN.CODE AS MIN_LEVEL
, LDEF.CODE AS DEF_LEVEL
, LROW.CODE AS ROW_LEVEL
FROM LBACSYS.OLS$POL P
, LBACSYS.OLS$USER_LEVELS UL
, LBACSYS.OLS$LEVELS LMAX
, LBACSYS.OLS$LEVELS LMIN
, LBACSYS.OLS$LEVELS LDEF
, LBACSYS.OLS$LEVELS LROW
WHERE P.POL#=UL.POL# AND UL.POL#=LMAX.POL# AND UL.POL#=LMIN.POL# AND UL.POL#=LDEF.POL# AND UL.POL#=LROW.POL# AND UL.MAX_LEVEL = LMAX.LEVEL# AND UL.MIN_LEVEL = LMIN.LEVEL# AND UL.DEF_LEVEL = LDEF.LEVEL# AND UL.ROW_LEVEL = LROW.LEVEL#