有时候,我们需要记录登陆用户登陆系统的信息,或在系统启动或用户登陆后对数据库进行一些设置, 可以使用系统触发器来实现,
创建一测试表,
SQL> create table user_logon (user_name varchar2(30),logon_date date);
Table created.
SQL> create or replace trigger logon_user_info
2 after logon on schema
3 begin
4
insert into user_logon values(user,sysdate);
5 end;
6 /
Trigger created.
SQL> select * from user_logon;
no rows selected
SQL> select * from user_logon;
USER_NAME
LOGON_DATE
------------------------------ ---------------------------------------------------------
SYSTEM
2006-05-25 10:06:22
当前Oracle不允许在SYS用户下创建系统触发器。
数据库级触发器
SQL> connect system/system
Connected.
SQL> create table user_logon
2 (a varchar2(30), b date);
Table created.
SQL>
SQL> create or replace trigger logon_user_info
2 after logon on database
3 begin
4
insert into user_logon values(user,sysdate);
5 end;
6 /
Trigger created.
SQL>
SQL> connect dinya/dinya;
Connected.
SQL> connect system/system
Connected.
SQL> select * from user_logon;
A
B
------------------------------ -----------------------------------
DINYA
25-MAY-06
SYSTEM
25-MAY-06
SQL>
以上只是记录用户和用户的登陆时间, 需要的话可以记录其他的信息,