oracle-databasecomputer-forensics

What happened to my table in my oracle database?

I have a situation where yesterday my code was working ok, but today I find that my code fails because a SQL query fails on my Oracle database. The query fails because the table used in the query does not exists. I am no Oracle expert so I am reaching out to you Oracle experts out there. Is there a way to see in a log file or log table when my table disappeared and who dropped my table?

Thanks

Solution

  • Depending on previous configuration one would hope that a production database would have auditing turned on. Try

    select * from sys.AUD$

    The audit table can log almost every user action including dropping tables or revoking grants but has to be configured.