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'