/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

9 votes318 views4 answers
Mysql show table fields
SQL
2 votes324 views2 answers
Exec procedure pl sql
SQL
0 vote377 views3 answers
Mysql keyword search
SQL
26 votes345 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote371 views1 answer
Sqlite version check
SQL
1 vote343 views4 answers
Sequelize migration default value
SQL
0 vote347 views1 answer
Mysql select smaller of two values
SQL
1 vote337 views1 answer
Create index concurrently postgres
SQL
8 votes334 views1 answer
Oracle search source code
SQL
16 votes355 views6 answers
Install sqlite3 python
SQL