title: Oracle sql, trigger on tables in different schemes
body: <p>I use following sql to create my trigger</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER INSERT_LOG
  AFTER INSERT 
  ON EXTERNAL_SCHEME.PAYMENT
  FOR EACH ROW
  
  BEGIN
  INSERT INTO MY_SCHEMA.DM_LOGGER(ID, TECHNOLOGY, WORKFLOW, NAME_EVENT, TIME_EVENT)
  VALUES (PAYMENT.id, 'Repository', 'UP', (select repo.name from
  pay_repository repo join pay_pmt pay on repo.id = pay_pmt.repository_id
  where repo.id = pay.repository_id),(select to_char(SYSDATE, 'hh24:mi:ss') from dual));
  END;
  </code></pre>
  
  <p>When I execute this trigger I get following exception:</p>
  
  <pre><code>01031. 00000 -  "insufficient privileges"
  *Cause:    An attempt was made to change the current username or password
  without the appropriate privilege. This error also occurs if
  attempting to install a database without the necessary operating
  system privileges.
  
  When Trusted Oracle is configure in DBMS MAC, this error may occur
  if the user was granted the necessary privilege at a higher label
  than the current login.
  
  *Action:   Ask the database administrator to perform the operation or grant
  the required privileges.
  
  For Trusted Oracle users getting this error although granted the
  the appropriate privilege at a higher label, ask the database
  administrator to regrant the privilege at the appropriate label
  </code></pre>
  
  <p>I don't get it. I have connection to both schemes and I never want to change something. What is wrong?</p>