Synonyms

You can access tables in another schema by specifying the schema name followed by the table. For employee table in the store schema, store.employee is used. You can avoid referencing schema name by creating a synonym for that table. A Synonym is created by CREATE SYNONYM command.


GRANT CREATE SYNONYM TO steve;
CREATE SYNONYM employee FOR store.employee;
Home »
Oracle »
User, Privilege, Role » 

Synonyms:
  1. Synonyms
  2. Public Synonyms
Related: