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

3 votes174 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote161 views1 answer
Postrgres trunc
SQL
1 vote122 views1 answer
File /etc/init.d/mysql not exists
SQL
1 vote188 views1 answer
Postgres get month name from date
SQL
0 vote131 views1 answer
Psql not found windows
SQL
1 vote175 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
1 vote135 views1 answer
Oracle boolean to varchar
SQL
3 votes176 views4 answers
Show databases in sql server
SQL
79 votes535 views6 answers
Grepper code
SQL
1 vote179 views1 answer
Update foreign key value in mysql
SQL