title: Access right on synonym and underlying table
body: <p>1/ How are privileges on synonyms and underlying objects related ? If one has rights on synonym, would he automatically has rights on the table and vice versa ?</p>
  
  <p><a href="https://docs.oracle.com/cd/B28359_01/server.111/b28310/views003.htm" rel="noreferrer">Oracle</a> says</p>
  
  <blockquote>
    <p>When you grant object privileges on a synonym, you are really granting
    privileges on the underlying object, and the synonym is acting only as
    an alias for the object in the GRANT statement</p>
  </blockquote>
  
  <p>which means privilege on synonym is enough. That will bypass table privilege.</p>
  
  <p><a href="https://community.oracle.com/thread/2161756?start=0&amp;tstart=0" rel="noreferrer">Another source</a> says that access right on table is enough and synonym privilege has no meaning.</p>
  
  <p>Does it mean either privilege on the synonym or the underlying table is enough ?</p>
  
  <p>2/ Is the behavior the same for private and public synonym. I haven't really seen an example of granting privileges on synonyms for a user to "see/access". How to grant privilege on private synonyms to a user ? </p>