/SQL/Oracle trigger after logon on schema

Oracle trigger after logon on schema

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
How to add timestamp column in mysql
SQL
0 vote99 views1 answer
Sql server remove 0 from left
SQL
4 votes107 views2 answers
Error loading MySQLdb module.
SQL
11 votes97 views1 answer
Oracle insert into where
SQL
2 votes101 views1 answer
Get hour from date sql
SQL
0 vote99 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote116 views1 answer
Show table status command in mysql
SQL
1 vote227 views2 answers
Sql unique rows
SQL
0 vote142 views1 answer
Sql count matching group by
SQL
0 vote79 views1 answer
Separator mysql
SQL