/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

16 votes277 views2 answers
Add column to all tables after first column mysql
SQL
0 vote271 views2 answers
Postgresql display subquery as json
SQL
0 vote274 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote264 views1 answer
Sql last 7 days
SQL
0 vote304 views2 answers
Check if sql temp table exists
SQL
3 votes255 views1 answer
Oracle nextval
SQL
0 vote260 views1 answer
Add alternate add column sql
SQL
0 vote273 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote266 views1 answer
Sql server split string and insert into table select
SQL
0 vote283 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL