As an alternative, consider using the AUDIT command if all you're going = to do is store who, what, and when. Rich Rich Jesse System/Database Administrator rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA > -----Original Message----- > From: Juan Cachito Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx] > Sent: Friday, April 30, 2004 3:00 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: OT: My no weekly tip ddl auditing >=20 >=20 > ( the reason to change the name is because mladlen asked not=20 > to do weekly > tips, so from now I do no weekly tips) >=20 > Hi, to create triggers for ddl auditing, > to know who was the responsible to create the table test or=20 > drop the table > sensitive_data >=20 > you can create database trigger ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------