/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 vote117 views1 answer
Python connect microsoft sql server
SQL
1 vote137 views1 answer
SQL Integer devision
SQL
1 vote121 views1 answer
Oracle split string
SQL
-3 votes116 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
1 vote114 views1 answer
Postgresql filter on
SQL
0 vote127 views1 answer
Multiple replace value mssql
SQL
-1 vote117 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote133 views1 answer
Get current date in pyspark sql
SQL
0 vote119 views2 answers
How to update the multiple rows in sql
SQL
1 vote116 views1 answer
Where to locate set password for mysql
SQL