17 PL/SQL DDL&&SYS触发器

create table log_table(
  username varchar2(20),
  logon_time date,
  logoff_time date,
  address varchar2(20)
);

create or replace trigger sys_trig1
after logon on database
begin
  insert into log_table(username,logon_time,address)
  values(ora_login_user,sysdate,ora_client_ip_address);
end;

create or replace trigger sys_trig2
before logoff on database
begin
  insert into log_table (username,logoff_time,address)
  values(ora_login_user,sysdate,ora_client_ip_address);
end;

 

create table my_ddl_record(
  username varchar2(20),
  ddl_time date,
  event varchar2(20)
);

create or replace trigger ddl_trig
after ddl on scott.schema
begin
  insert into my_ddl_record values(ora_login_user,sysdate,ora_sysevent);
end;

alter trigger trig1 disable;
alter trigger trig1 enable;
alter table test disable all triggers;
alter table test enable all triggers;
drop trigger trig1;