( the reason to change the name is because mladlen asked not to do weekly tips, so from now I do no weekly tips) Hi, to create triggers for ddl auditing, to know who was the responsible to create the table test or drop the table sensitive_data you can create database trigger CREATE OR REPLACE TRIGGER SYS.TGR_DROP AFTER DROP ON DATABASE BEGIN END; / CREATE OR REPLACE TRIGGER SYS.TGR_CREATE AFTER CREATE ON DATABASE BEGIN END; / To get the object information you can use DBMS_STANDARD.LOGIN_USER,SYSDATE, DBMS_STANDARD.DICTIONARY_OBJ_NAME, DBMS_STANDARD.dictionary_obj_type Here is an example http://www.odtug.com/2000papers/cassidy.pdf Juan Carlos Reyes Pacheco OCP Database 9.2 Standard Edition ---------------------------------------------------------------- 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 -----------------------------------------------------------------