/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

1 vote228 views1 answer
Show databases mysql docker
SQL
0 vote198 views1 answer
Get who is hired in specific month in sql
SQL
16 votes189 views2 answers
Gremove folder from git
SQL
0 vote210 views1 answer
Ubuntu connect to mssql database
SQL
7 votes196 views1 answer
Oracle set sequence value to max(id)
SQL
23 votes194 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote214 views1 answer
Select all columns except one sql
SQL
-1 vote191 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
1 vote202 views1 answer
Find a column in all tables postgres
SQL
5 votes220 views2 answers
Oracle find all tables with column name
SQL