User Privilege Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. User Privilege
  4. Public Synonyms
Even though a public synonym has been created for schemaName.tableName, a user still needs object privileges
on that table to actually access the table.

CREATE PUBLIC SYNONYM products FOR schemaName.tableName;