Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Catch table droppers

Catch table droppers

From: <krishnanand_at_hotmail.com>
Date: 1997/10/24
Message-ID: <877670798.13079@dejanews.com>#1/1

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 Fri Oct 24 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US