tracking history of DML in oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: tracking history of DML in oracle

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    singapore
    Posts
    19
    can we know history of previous SQL quries applied on the database from different user.like what all they do and which record is deleted by who with IP address of the user.
    Can i get this info from ne of the data Dictionary tables or ne logs. thanx in advice.
    thanx with regards,
    Raj

  2. #2
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    if i am not wrong ..this can be achieved...but u need to turn on archiving and
    also use the LogMiner utility by Oracle to trace any transactions by any users.

    junior

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    No, not really, not without auditing the user sessions. Another alternative is to set up an AUDIT table and and INSERT, UPDATE, DELETE trigger on the table/s you wish to monitor.

    Cheers

  4. #4
    Join Date
    May 2001
    Location
    singapore
    Posts
    19
    hi tthanx for attention ,one more this yet am not clear is that six clients using same Usernmae/passwd how to identify them (like gettng IP).will above fix this already?
    ---Raj
    thanx with regards,
    Raj

  5. #5
    Join Date
    Jan 2001
    Posts
    153
    u can find out the list of command fired from V$SQLTEXT. Take the hashaddress and find out the corresponding details from V$OPEN_CURSOR
    Vijay.s

  6. #6
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Get their corresponding SID, Serial#, OSUSER from v$sesson to determine the different users.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ora_client_ip_address

    VARCHAR2

    Returns the IP address of the client in a LOGON event, when the underlying protocol is TCP/IP
    if (ora_sysevent = 'LOGON')
    then addr := ora_client_ip_
    address;
    end if;


    select sys_context('userenv','ip_address')
    from dual;




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