title: how to grant references in oracle sql 12.2.0.1.0?
body: <p>I'm trying to grant user1 permission to create (and alter) tables in other schemas. So far i've been able to create "simple" tables. But when it come to create tables with foreign keys got error </p>
  
  <p>I have oracle database 12c with 2 users/schemas. User1 granted permissions to create tables in user2 schema:</p>
  
  <p><code>grant create any table to user1</code></p>
  
  <p>(ok, probably not the best solution but doesn't matter right now)</p>
  
  <p>now when i'm trying to create table with foreign key i'm getting standard message</p>
  
  <p><code>Error: ORA-01031: insufficient privileges
   [Failed SQL: create table…</code></p>
  
  <p>i've been trying</p>
  
  <p><code>grant references to user1</code></p>
  
  <p>solution from this <a href="https://stackoverflow.com/questions/39747611/how-to-grant-references-permission-to-all-tables">question</a></p>
  
  <p>got</p>
  
  <p><code>ORA-01924: role 'REFERENCES' not granted or does not exist</code></p>
  
  <p>(ok, it's true, there is no role 'REFERENCES' but i don't need new role or i don't understand how it will help in this situation)</p>
  
  <p>also</p>
  
  <p><code>grant references on testTable to user1</code></p>
  
  <p>works but i need to be able to grant permission to any table even for those that will be created in future</p>