audit truncate table (classic)

BY: Brian Fitzgerald

[oracle@waipio1 wailua20 AUDIT]$ cat AUDIT.TRUNCATE.TABLE.classic.SQL
COLUMN username format a30
COLUMN owner format a30
COLUMN obj_name format a30
COLUMN action_name format a30
SET linesize 200
SET trimspool ON

DROP USER sch CASCADE;
CREATE USER sch IDENTIFIED BY sch account LOCK;
CREATE TABLE sch.t ( n NUMBER );
DROP USER brian CASCADE;
NOAUDIT TABLE;
CREATE USER brian IDENTIFIED BY brian;
GRANT dba TO brian;

CONNECT brian/brian;
TRUNCATE TABLE sch.t;

CONNECT / AS sysdba
SELECT username, owner, obj_name, action_name
FROM dba_audit_trail
WHERE owner = 'SCH'
AND obj_name = 'T'
AND TIMESTAMP > SYSTIMESTAMP - 5/86400;

AUDIT TABLE;

CONNECT brian/brian

TRUNCATE TABLE sch.t;

CONNECT / AS sysdba
SELECT username, owner, obj_name, action_name
FROM dba_audit_trail
WHERE owner = 'SCH'
AND obj_name = 'T'
AND TIMESTAMP > SYSTIMESTAMP - 5/86400;
quit
[oracle@waipio1 wailua20 AUDIT]$ sqlplus / AS sysdba @ AUDIT.TRUNCATE.TABLE.classic.SQL

SQL*Plus: RELEASE 12.1.0.1.0 Production ON Wed Jun 11 21:06:47 2014

Copyright (c) 1982, 2013, Oracle.  ALL rights reserved.


Connected TO:
Oracle DATABASE 12c Enterprise Edition RELEASE 12.1.0.1.0 - 64bit Production
WITH the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
AND REAL Application Testing options


USER dropped.


USER created.


TABLE created.


USER dropped.


NOAUDIT succeeded.


USER created.


GRANT succeeded.

Connected.

TABLE truncated.

Connected.

no ROWS selected


AUDIT succeeded.

Connected.

TABLE truncated.

Connected.

USERNAME                       OWNER                          OBJ_NAME                       ACTION_NAME
------------------------------ ------------------------------ ------------------------------ ------------------------------
BRIAN                          SCH                            T                              TRUNCATE TABLE

Disconnected FROM Oracle DATABASE 12c Enterprise Edition RELEASE 12.1.0.1.0 - 64bit Production
WITH the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
AND REAL Application Testing options