/SQL/Oracle trigger after logon on schema

Oracle trigger after logon on schema

CREATE OR REPLACE TRIGGER my_schema.trigger_name AFTER LOGON ON DATABASE
BEGIN
    INSERT INTO my_log_table
    VALUES (USER AS CONNECTED_USER,
        sys_context('USERENV', 'SESSIONID') AS SESSION_ID,
        substr(sys_context('USERENV', 'OS_USER'), 1, 50) AS OS_USER,
        substr(sys_context('USERENV', 'HOST'), 1, 30) AS HOST,
        SYSDATE AS LOGON_DATE);
END;
ALTER TRIGGER my_schema.trigger_name ENABLE;

Similar codes

2 votes151 views1 answer
Sql server check for value in multiple columns
SQL
0 vote164 views1 answer
Codigo crear tablas sql server
SQL
0 vote151 views1 answer
Sql ignore
SQL
11 votes264 views2 answers
Import mysql dump command line windows
SQL
57 votes338 views6 answers
Mysql alter table add column
SQL
9 votes164 views3 answers
Sequence postgresql
SQL
0 vote139 views1 answer
Tsql delete all rows
SQL
2 votes222 views1 answer
Postgresql group by month and year
SQL
0 vote142 views1 answer
Sql pivot without aggregate
SQL
22 votes152 views3 answers
Remove all records from table mysql
SQL