/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

2 votes189 views1 answer
Select from array in psql
SQL
0 vote242 views1 answer
Database timezone
SQL
0 vote217 views1 answer
Select milliseconds mysql
SQL
0 vote150 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote149 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
4 votes155 views2 answers
Postgre sql create table
SQL
3 votes148 views3 answers
Into in sql
SQL
2 votes191 views1 answer
Sql missing records from another table
SQL
24 votes168 views5 answers
List mysql users
SQL
0 vote154 views1 answer
Add unique constraint sql server multiple columns
SQL