Basic HTML version of Foils prepared 7 October 97

Foil 28 Major Schema Objects in Oracle -VII-Synonym

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
Synonyms are used to
  • mask the real name and owner of an object
  • provide public access to an object
  • provide location transparency for tables, views, or program units of a remote database
  • simplify the SQL statements for database users
For example, to allow all users to share the WOW PL/SQL package called htp which is currently owned by a user 'cps616'. A public synonym must be created and certain permissions must be granted:
  • CREATE PUBLIC SYNONYM htp for cps616.htp
  • GRANT execute on htp to public

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jan 27 1998