Audit table oracle10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Audit table oracle10g

  1. #1
    Join Date
    Jun 2007
    Posts
    59

    Audit table oracle10g

    Hi
    I have
    audit_trail string TRUE in init.ora
    then I run audit all or audit table in slqplus
    Audit succeeded.
    Now I create table abc using user alexz
    drop table and create it again/
    insert into abc a values (1);
    select obj_name,action_name,username from dba_audit_trail where obj_name='ABC';

    OBJ_NAME ACTION_NAME USERNAME
    -------------------- ---------------------------- ------------------------------
    ABC DROP TABLE ALEXZ
    ABC CREATE TABLE ALEXZ

    Where is the trace for insert ?
    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,460

    Talking Hidden in the UNDO.

    Did you COMMIT?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width