title: create synonym ora-01031 insufficient privileges
body: <p>I need help understanding what grants/privileges a user needs to CREATE a SYNONYM when it points to another (different) schema object.</p>
  
  <p>When I try the below, I get ora-01031 insufficient privileges, so obviously I am missing and failing to apply other needed privileges. I did search as well as I could but couldn't find anything specific to cross-schema synonyms.</p>
  
  <pre><code>CREATE USER test IDENTIFIED BY pw DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
  ALTER USER test IDENTIFIED BY pw;
  GRANT CONNECT, RESOURCE TO test;
  
  -- ... create a bunch of stuff in test...
  
  CREATE USER READWRITE IDENTIFIED BY pw DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE    TEMP;
  ALTER USER READWRITE IDENTIFIED BY pw;
  GRANT CONNECT, RESOURCE TO READWRITE;
  
  GRANT SELECT ON GDACS.FIXALARMS TO PUBLIC;
  GRANT UPDATE, INSERT ON GDACS.FIXALARMS TO READWRITE; 
  
  CONNECT READWRITE/pw;
  
  CREATE SYNONYM FIXALARMS for test.FIXALARMS;
  ORA-01031 insufficient privileges
  </code></pre>