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

0 vote345 views2 answers
Database owner can't create new tables postgres
SQL
0 vote359 views1 answer
Db format in quotation
SQL
14 votes371 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote362 views1 answer
Mysql not defined
SQL
8 votes412 views6 answers
Sql insert
SQL
0 vote369 views1 answer
Create schema sql server
SQL
4 votes377 views3 answers
Rename table column postgresql
SQL
0 vote373 views1 answer
Incorrect string value: mysql
SQL
0 vote338 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote385 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL