Public Synonyms

You can create a public synonym for a table in order to let all users see the table.


CREATE PUBLIC SYNONYM employee FOR store.employee;

A user needs object privileges on that table to access the table, even though a public synonym has been created.

Home »
Oracle »
User, Privilege, Role » 

Synonyms:
  1. Synonyms
  2. Public Synonyms
Related: