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

11 votes131 views3 answers
Python sqlite3 create table if not exists
SQL
22 votes157 views1 answer
Mysql workbench
SQL
4 votes74 views1 answer
Generate class from sql table c#
SQL
0 vote118 views1 answer
Soql more than today
SQL
0 vote144 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote131 views1 answer
Sql column contains special character
SQL
0 vote133 views1 answer
Less than and between in sql query
SQL
3 votes125 views3 answers
Create table in microsoft sql server
SQL
3 votes141 views1 answer
Oracle apex message quit website
SQL
0 vote116 views1 answer
Get all employee of salary if more than in sql
SQL