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

3 votes198 views1 answer
Sql multiple column index
SQL
21 votes199 views3 answers
Average sql
SQL
0 vote200 views1 answer
Query to insert image
SQL
0 vote239 views1 answer
How to make sure two tables have same exact data in sql
SQL
3 votes195 views2 answers
Having in mysql
SQL
0 vote206 views1 answer
Power bi find all ids not in other tables
SQL
7 votes192 views1 answer
Sql management studio display line numbers
SQL
0 vote227 views1 answer
Select * from mysql.proc
SQL
0 vote219 views3 answers
Fetlife
SQL
0 vote205 views1 answer
Mariadb datetime change to microseconds
SQL