auditing .. urgent please

[ggnanaraj]

You can use ...by access

audit delete table by  scott by access;

then you get ...values of delete in ..

select action, action_name, username
        from dba_audit_trail;


   ACTION ACTION_NAME                 USERNAME
--------- --------------------------- ---------------------
      103 SESSION REC                 RMAN
      103 SESSION REC                 RGG
      103 SESSION REC                 SCOTT
      103 SESSION REC                 SCOTT
        1 CREATE TABLE                SCOTT
        1 CREATE TABLE                SCOTT
        1 CREATE TABLE                RGG
      103 SESSION REC                 SCOTT
        2 INSERT                      SCOTT
        2 INSERT                      SCOTT
        2 INSERT                      SCOTT
        2 INSERT                      SCOTT
        2 INSERT                      SCOTT
        7 DELETE                      SCOTT

14 rows selected.

SQL>

Cheers.