CREATE TABLE db_users_actions (
  user_id   NUMBER( 5 ) DEFAULT UID,
  action    VARCHAR2( 50 ),
  terminal  VARCHAR2( 10 ) DEFAULT USERENV('TERMINAL'),
  timestamp DATE DEFAULT SYSDATE
);
CREATE PUBLIC SYNONYM db_users_actions FOR db_users_actions;

CREATE OR REPLACE TRIGGER trg_db_logon AFTER LOGON ON DATABASE
BEGIN
  INSERT INTO db_users_actions (action) VALUES ('Вход в систему');
END;
/

CREATE OR REPLACE TRIGGER trg_db_logoff BEFORE LOGOFF ON DATABASE
BEGIN
  INSERT INTO db_users_actions (action) VALUES ('Выход из системы');
END;
/

CREATE OR REPLACE TRIGGER trg_db_startup AFTER STARTUP ON DATABASE
BEGIN
  INSERT INTO db_users_actions (action) VALUES ('STARTUP базы данных');
END;
/

CREATE OR REPLACE TRIGGER trg_db_shutdown BEFORE SHUTDOWN ON DATABASE
BEGIN
  INSERT INTO db_users_actions (action) VALUES ('SHUTDOWN базы данных');
END;
/