Record of deleted tables [message #10763] |
Mon, 16 February 2004 08:33 |
Eduardo Guevara
Messages: 3 Registered: February 2004
|
Junior Member |
|
|
Hi, I was wondering if someone could help me with this...
Last week someone or something deleted all the records of two tables, and the only one who has access to the SQL is myself, so I was wondering if there is a way to know who did it? Maybe Oracle has an internal log that records this, or maybe with an external aplication I can know which user did it?
I have my doubts if someone else has the rights or grants to do it, cause though the application you can't do it, because of triggers and stuff.
If so, then I will disscard the option that maybe something crashed in my system and did it without me taking notice of it. And if it wasn't a user then I'll start reviewing my triggers and SP to see if something might have caused it.
Thank you very much in advance
|
|
|
Re: Record of deleted tables [message #10764 is a reply to message #10763] |
Mon, 16 February 2004 09:06 |
sverch
Messages: 582 Registered: December 2000
|
Senior Member |
|
|
My first thought is
SELECT sql_text, PARSING_USER_ID, FIRST_LOAD_TIME FROM V$SQL where sql_text like '%DELETE%';
But there could be other options I am sure
|
|
|
|
|