Strange Problem !!
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....
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$)
2. Use logminer...
Fast, Cheap, Reliable... Pick Two(2)
Turn on SQL logging in ODBC would be a quick way
Click Here to Expand Forum to Full Width