Re: Catch table droppers

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/10/25
Message-ID: <62s78e$l8e@bgtnsc01.worldnet.att.net>#1/1

You may have to write a PL/SQL procedure to be executed through DBMS_JOB every few minutes, to check the V$SQLAREA (SQL_TEXT column) for 'DROP TABLE ...' statements; then look up the V$SESSION table for the user information you need.Then use DBMS_SQL to create SQL statements to insert the information into your history table.

Hope this helps.

Michael Serbanescu

---

On Fri, 24 Oct 1997 00:39:22 -0600, krishnanand_at_hotmail.com wrote:

>Hi,
>
> Problem:
>
> I wish to trace out the people who drop any table in the Database &
>store details like username,date of action,... etc in a history table
>accessible only to me.
>
> " I can't USE the database auditing feature for this purpose
> since currently our DB is not audited and if I wish to start
> auditing I need to edit AUDIT_TRAIL , shutdown and startup the
> databse, which I am strictly porhibited from doing currently."
>
> I tried creating Triggers on sys.obj$ as SYS but still it says
> can't create triggers on objects owned by SYS.
>
> Is there any other way ?
>
> Thanx.
>
> Platform: Oracle 7.3 on HP-UX 10.20
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Sat Oct 25 1997 - 00:00:00 CDT