DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Strange Problem !!

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    Strange Problem !!

    Hello all..

    We have a 3rd party tool that we use to keep track of the time each person worked on each project...This application is Connected to Oracle 9.2 thru ODBC connection

    Now In this Application, we have GUI screens and one of the screens 'Customer screen' lets us to create/modify USER id and password. Once we modify the data, it tells you what time the data is modified at the bottom of the screen.

    Now I need to find out which table in DB is getting updated when i make a change to 'customer Screen'.

    This application uses about 70 tables....
    So my question is Is there a Way to find out which table is this Customer Info stored like Id's and Passsword. I have seen a table that has the ID's. But no password Field....

    Thanks
    Ron

  2. #2
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    There are several options


    1. In your test system:

    Turn on auditing in the DB (Audit ALL)

    Log on to your application and perform your 'Customer screen' create/update/delete.

    Check the Oracle audit table (SYS.AUD$)

    or

    2. Use logminer...
    alapps

    Fast, Cheap, Reliable... Pick Two(2)

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Turn on SQL logging in ODBC would be a quick way
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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