DBA Data[Home] [Help]

VIEW: LBACSYS.DBA_SA_AUDIT_OPTIONS

Source

View Text - Preformatted

SELECT a.policy_name, a.user_name, APY, REM, SET_, PRV
  FROM LBACSYS.dba_lbac_policies p, LBACSYS.dba_ols_audit_options a
  WHERE p.policy_name = a.policy_name AND
        p.package = 'LBAC$SA'
View Text - HTML Formatted

SELECT A.POLICY_NAME
, A.USER_NAME
, APY
, REM
, SET_
, PRV
FROM LBACSYS.DBA_LBAC_POLICIES P
, LBACSYS.DBA_OLS_AUDIT_OPTIONS A
WHERE P.POLICY_NAME = A.POLICY_NAME AND P.PACKAGE = 'LBAC$SA'