1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
| SQL> conn / as sysdba
Connected.
SQL> grant select on v_$session to public;
Grant succeeded.
SQL> conn system/manager
Connected.
SQL> create table nbsession (nb number, date# date);
Table created.
SQL> create public synonym nbsession for nbsession;
Synonym created.
SQL> grant insert,select on nbsession to public;
Grant succeeded.
SQL>
SQL>
SQL> CREATE OR REPLACE TRIGGER my_trigger AFTER LOGON ON DATABASE
2 DECLARE
3 var_nb number;
4 pragma autonomous_transaction;
5 BEGIN
6 insert into nbsession (nb, date#) select count(*), sysdate from v$session;
7 commit;
8 END;
9 /
Trigger created.
SQL>
SQL> show err
No errors.
SQL>
SQL> conn H89UCBAC/H89UCBAC
Connected.
SQL> select * from nbsession;
NB DATE#
---------- ---------------
36 14-FEB-07
SQL> |
Partager