Logon schema logon to a table : Schema Trigger « Trigger « Oracle PL / SQL






Logon schema logon to a table

 
SQL>
SQL> CREATE TABLE MyTable (
  2    num_col    NUMBER,
  3    char_col   VARCHAR2(60)
  4    );

Table created.

SQL>
SQL>
SQL> CREATE OR REPLACE TRIGGER LogUserAConnects
  2    AFTER LOGON ON SCHEMA
  3  BEGIN
  4    INSERT INTO MyTable
  5      VALUES (1, 'LogUserAConnects fired!');
  6  END LogUserAConnects;
  7  /

Trigger created.

SQL>
SQL> drop table MyTable;

Table dropped.

SQL>

 








Related examples in the same category

1.log drop trigger on table schema
2.trigger to log the schema altercation
3.Trigger on schema creation