VIEW: LBACSYS.SA$POL

Source

View Text - Preformatted

SELECT pol#,
       pol_name,
       column_name,
       DECODE(bitand(flags,1),0,'DISABLED',1,'ENABLED','ERROR') AS status,
       lbac_cache.option_string(options) AS policy_options,
       pol_role as Admin_Role
  FROM LBACSYS.ols$pol
 WHERE package = 'LBAC$SA'

View Text - HTML Formatted

SELECT POL#
, POL_NAME
, COLUMN_NAME
, DECODE(BITAND(FLAGS
, 1)
, 0
, 'DISABLED'
, 1
, 'ENABLED'
, 'ERROR') AS STATUS
, LBAC_CACHE.OPTION_STRING(OPTIONS) AS POLICY_OPTIONS
, POL_ROLE AS ADMIN_ROLE
FROM LBACSYS.OLS$POL
WHERE PACKAGE = 'LBAC$SA'