auditopts_type

col user_name for a20
col audit_option for a20
SELECT user_name, audit_option, success, failure
FROM dba_stmt_audit_opts
WHERE audit_option LIKE '%USER%' UNION
SELECT user_name, privilege AS audit_option, success, failure
FROM dba_priv_audit_opts
WHERE privilege LIKE '%USER%' UNION
SELECT owner AS user_name, object_name AS audit_option, NULL AS success, NULL AS failure
FROM dba_obj_audit_opts
WHERE owner <> 'SYS' AND object_type = 'USER' ORDER BY 1,2;