N
N
Nikolay Baranenko2017-09-12 23:43:52
Oracle
Nikolay Baranenko, 2017-09-12 23:43:52

What rights are needed to create a trigger?

Hello.
I'm trying to create a trigger that responds to INSERT and UPDATE operations in a table from another schema UM_EVENTS.ALL_EVENTS

CREATE OR REPLACE TRIGGER ALL_EVENTS_LOG
  AFTER INSERT or UPDATE ON UM_EVENTS.ALL_EVENTS
FOR EACH ROW
declare
  -- local variables here
begin
if inserting then
  insert into WAREHOUSE.ALL_EVENTS_LOG
  (ID, TYPE, TIME_RECEIVED)
  values(
         :NEW.ID,
         'INSERT',
         sysdate) ;
  END IF;
if updating then
  insert into WAREHOUSE.ALL_EVENTS_LOG
  (ID, TYPE, TIME_RECEIVED)
  values(
         :OLD.ID,
         'UPDATE',
         sysdate) ;
  END IF;
end ALL_EVENTS_LOG;

when trying to create a trigger, the error ORA-01031 insufficient privileges occurs and the developer emphasizes UM_EVENTS.ALL_EVENTS
access to select to UM_EVENTS.ALL_EVENTS is,
what rights are still needed?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
roswell, 2017-09-13
@drno-reg

The right and is called - CREATE ANY TRIGGER.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question