/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 vote118 views1 answer
Select 1 from orders
SQL
0 vote120 views2 answers
How to list all values of a column that start with a letter in sql
SQL
1 vote104 views1 answer
Sql find column name like
SQL
0 vote116 views1 answer
Sql today at midnight
SQL
0 vote104 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
1 vote105 views1 answer
Search for replace in mysql
SQL
2 votes106 views1 answer
Find all triggers in database
SQL
0 vote98 views1 answer
Starting mysql shell lampp ubuntu
SQL
18 votes96 views3 answers
Mysql number format
SQL
1 vote118 views1 answer
Postgres see sequence current state
SQL