/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 vote305 views1 answer
Grant access on table in oracle
SQL
0 vote321 views1 answer
Show create table in postgresql
SQL
0 vote293 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote339 views1 answer
Sql alter table add column if exists
SQL
5 votes322 views1 answer
Sql check if date is between 2 dates
SQL
0 vote340 views1 answer
Group by 15 minute interval sql server
SQL
0 vote328 views1 answer
Sql get number of days between two dates
SQL
5 votes359 views3 answers
Sql server utc to local
SQL
0 vote307 views1 answer
Deny select insert update delete sql
SQL
0 vote307 views1 answer
Search db for table name
SQL