Hi All
I need to enable auditing for specific user ,
Command :
AUDIT INSERT ANY TABLE, UPDATE ANY TABLE , DELETE ANY TABLE BY TREVOR;
When i retrieve data from dba_audit_trail there are only data which are done to own objects, there are no any records for other schema objects.
sql:
SELECT *
FROM DBA_AUDIT_TRAIL
WHERE USERNAME = 'TREVOR' ;
I need to get audit records done by this user to other schema objects , What is the issue with my command ? how can i overcome this ?
Thank You
Malith