Re: Audit object

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Tue, 18 May 2004 09:05:08 -0700 (PDT)
Message-ID: <20040518160509.16865.qmail@web80503.mail.yahoo.com>

The best way to do this would be to write a trigger you can write triggers on create alter & drop also utilizing oracle event attributes you can leverage more infomration like ip addres osuser and stuff http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg14evt.htm#998000 specifies all the event attributes that you can use to write the trigger.

"Smith, Ron L." <rlsmith_at_kmg.com> wrote: How do I audit DDL changes to all objects?

Ron Smith

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue May 18 2004 - 11:02:16 CDT