/SQL/Oracle trigger after logon on database

Oracle trigger after logon on database

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 vote110 views1 answer
Sql fetch next 10 rows pdo
SQL
5 votes122 views1 answer
Oracle list packages
SQL
0 vote117 views1 answer
Mysql drop trigger
SQL
2 votes108 views1 answer
Postgresql left join distinct on
SQL
7 votes130 views2 answers
Sql remove duplicates based on column
SQL
0 vote142 views1 answer
Edit shchima table in sql
SQL
0 vote144 views1 answer
Sql filter rows with condition
SQL
1 vote121 views1 answer
How to subtract from the value of a table in sql
SQL
16 votes115 views6 answers
Mysql find and replace
SQL
2 votes132 views1 answer
Sql percentage with % rounded down
SQL