/SQL/Oracle trigger after logon on database

Oracle trigger after logon on database

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 vote155 views1 answer
Shortcut run sql pgadmin
SQL
1 vote128 views1 answer
Top 10 rows in mysql
SQL
0 vote126 views2 answers
Sql update top 100
SQL
3 votes124 views2 answers
Update Query in SQL Server
SQL
1 vote142 views1 answer
Create index concurrently postgres
SQL
1 vote141 views2 answers
Sql multiline comment
SQL
1 vote109 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
1 vote129 views1 answer
Mysql list bigger table
SQL
0 vote136 views1 answer
Hex string sql becomes int64
SQL
0 vote124 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL