Oracle trigger after connect

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

10 votes92 views1 answer
Oracle dependency
SQL
0 vote128 views1 answer
Sql delete caracter list
SQL
9 votes106 views4 answers
SQL Date Format
SQL
10 votes61 views2 answers
Django mysql
SQL
0 vote119 views1 answer
Mysql dump for selected row
SQL
0 vote108 views2 answers
How to check if a column exists in a SQL Server table?
SQL
2 votes65 views1 answer
Sql float to int
SQL
1 vote119 views1 answer
How to print longest name in sql
SQL
0 vote117 views1 answer
Learnxinyminutes sql
SQL
0 vote100 views1 answer
Database db connection string format
SQL