create or replace trigger dbtest_audit_droptable
before drop on schema
declare
begin
insert into dbtest_audit_info values (
sys_context('userenv','os_user'),
sys_context('userenv','terminal'),
sys_context('userenv','host'),
sys_context('userenv','ip_address'),
sys.dictionary_obj_name,
sys.sysevent,
to_char(sysdate,'yyyy-mm-dd hh24:mm:ss'));
end dbtest_audit_droptable; |