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 /
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 /