title: grant to create synonyms on another schema (Oracle)
body: <p>I just wondering if there any option to grant permission to create synonyms on different schema without giving 'ANY' option. I just want to narrow down the grant to provide permission with what is required for security purpose. </p>
  
  <p>We have created a schema name A which related to application product. But the application suppose to access the object through another (login) schema B. We have granted resource to schema A so schema A owner can creates its own objects. What grant syntax i need to use to grant Schema A to create synonyms on schema B, so it can create synonyms. </p>
  
  <p>End result should be as below and can be created by schema owner A without interference of DBA</p>
  
  <pre><code>B.b_synonym maps to A.b_object
  </code></pre>