AUDIT TABLE

Audit_trail



ALTER SYSTE SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE

SHU IMMEDIATE
STARTUP

AUDIT ALL BY HR BY ACCESS;
AUDIT SELECT TABLE , UPDATE TABLE, INSERT TABLE, DELETE TABLE BY HR BY ACCESS;
AUDIT EXECUTE PROCEDURE BY HR BY ACCESS

VIEW AUDIT TRAIL

SELECT VIEW NAME
FROM DBA_VIEWS
WHERE VIEW_NAME LIKE 'DBA%AUDIT%'


BASE TABLE

DESC AUD$

SELECT USERNAME,EXTENDED_TIMESTAMP,OWNER,OBJ_NAME,ACTION_NAME FROM DBA_AUDIT_TRAIL
WHERE OWNER='HR'