audit records of an user: - Oracle Database Script.
col user_name
FOR a12 heading "User name" col timest format a13 col userid format a8 trunc col obn format a10 trunc col name format a13 trunc col object_name format a10 col object_type format a6 col priv_used format a15 trunc
SET verify OFF
SET pages 1000
SET PAGESIZE 200
SET LINES 299
SELECT username userid,
to_char(TIMESTAMP, 'dd-mon hh24:mi') timest,
action_name acname,
priv_used,
obj_name obn,
ses_actions
FROM sys.dba_audit_trail
WHERE TIMESTAMP>sysdate-&HOURS*(1/24)
AND username='&USER_NAME'
ORDER BY TIMESTAMP /