title: Foreign keys in alternate schemas with Oracle?
body: <p>I have two schemas, let's call them BOB and FRED. I need to call a table in schema FRED from schema BOB to use the primary key in that table as a foreign key. I've set up the appropriate grants for schema FRED to allow BOB access to it, but whenever I run the script, it complains that I do not have the correct permissions. Is there another setting that I need to change somewhere? Can this even be done?</p>
  
  <p>My FK creation is as follows:</p>
  
  <pre><code>ALTER TABLE "BOB"."ITEMGROUP" WITH CHECK ADD CONSTRAINT FK_ITEMS_ITEM FOREIGN KEY (ItemID)
  REFERENCES "FRED"."ITEMS"(ItemID)
  </code></pre>
  
  <p>And I'm doing the grant with:</p>
  
  <pre><code>GRANT ALTER ON "FRED"."ITEMS" TO "BOB"
  </code></pre>
  
  <p>I get this error message:</p>
  
  <pre><code>SQL Error: ORA-01031: insufficient privileges 
  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>