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 vote208 views1 answer
Create table in dbms cmds
SQL
0 vote280 views1 answer
Varchar2 length in oracle
SQL
0 vote202 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
2 votes217 views2 answers
Sqlalchemy return id after insert
SQL
0 vote206 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote198 views1 answer
T-sql update table variale
SQL
0 vote234 views1 answer
Java spring boot connect to sql server
SQL
10 votes269 views6 answers
Mysql set root password
SQL
0 vote210 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote217 views1 answer
Oracle lower in where clause
SQL