Synonyms - inconvenient to use & reduce complexity of SQL statements

Discussion

• Nirja Shah   -Posted on 29 Sep 15
  - A synonym is an alias for a schema object.
  
  - Synonyms can provide a level of security by masking the name and owner of an object and by providing location transparency for remote objects of a distributed database.
  
  - Also, they are convenient to use and reduce the complexity of SQL statements for database users.
  
  - Synonyms allow underlying objects to be renamed or moved, where only the synonym needs to be redefined and applications based on the synonym continue to function without modification.
  
  - You can create both public and private synonyms.
  
  - A public synonym is owned by the special user group named PUBLIC and is accessible to every user in a database.
  
  - A private synonym is contained in the schema of a specific user and available only to the user and the user's grantees.

➨ Post your comment / Share knowledge