Public Synonyms : Synonyms « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. 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;








36.8.Synonyms
36.8.1.Synonyms
36.8.2.Public Synonyms
36.8.3.Creating a synonym for a table
36.8.4.Creating a public synonym
36.8.5.create a synonym for a view
36.8.6.Dropping a synonym
36.8.7.Dropping a public synonym
36.8.8.Query a table by selecting its synonym
36.8.9.Seeing SYNONYM in the Oracle data dictionary
36.8.10.Describe a synonym