Basic HTML version of Foils prepared 7 October 97

Foil 27 Major Schema Objects in Oracle -VI- Synonym

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
Synonym - an alias for a table, view, sequence, or program unit
A synonym is not actually an object itself, but instead is a direct reference to an object
A synonym can be public or private.
  • A Private synonym is only visible to the user who created it.
  • DBA most often create public synonyms that make the base schema object available for general, system-wide use by any database user

© 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