A synonym is an alias for a schema object of an Oracle tenant. You can create a synonym for a table, view, materialized view, sequence, stored procedure, function, package, object type, custom object type, or other objects. As an alias, a synonym requires no storage other than its definition in the data dictionary. This topic describes the types, basic features, and required privileges of synonyms.
Category
There are two types of synonyms: public synonyms and private synonyms.
A public synonym can be used by every database user and is owned by a group named PUBLIC. A private synonym is contained in the schema of a specific user and is available only to its owner and users who are granted access to the underlying object.
Public synonyms can be created by database administrators and regular users who are granted the CREATE PUBLIC SYNONYM privilege.
Basic features
Synonyms extend the availability of database objects and allow them to be accessed by different database users with the required privileges. This design simplifies and secures access to database objects.