CREATE SYNONYM command

http://www-eleves-isia.cma.fr/documentation/OracleDoc/CREATE-SYNONYM.html

PURPOSE:
To create a synonym. A synonym is an alternative name for a table,
view, sequence, procedure, stored function, package, snapshot, or
another synonym.

SYNTAX:

CREATE [PUBLIC] SYNONYM [schema.]synonym
FOR [schema.]object[@dblink]

where:

PUBLIC
creates a public synonym. Public synonyms are accessible to all
users. If you omit this option, the synonym is private and is
accessible only within its schema.

schema
is the schema to contain the synonym. If you omit schema, Oracle
creates the synonym in your own schema.

synonym
is the name of the synonym to be created.

FOR
identifies the object for which the synonym is created. If you do
not qualify object with schema, Oracle assumes that the object is in
your own schema. The object can be of these types:

* table
* view
* sequence
* stored procedure, function, or package
* snapshot
* synonym

The object cannot be contained in a package. Note that the object
need not currently exist and you need not have privileges to access
the object.

You can use a complete or partial dblink to create a synonym for an
object on a remote database where the object is located. If you
specify dblink and omit schema, the synonym refers to an object in
the schema specified by the database link. Oracle Corporation
recommends that you specify the schema containing the object in the
remote database.

If you omit dblink, Oracle assumes the object is located on the
local database.

PREREQUISITES:
To create a private synonym in your own schema, you must have CREATE
SYNONYM system privilege.

To create a private synonym in another user's schema, you must have
CREATE ANY SYNONYM system privilege. If you are using Trusted
Oracle in DBMS MAC mode, your DBMS label must dominate the creation
label of the owner of schema to contain the synonym.

To create a PUBLIC synonym, you must have CREATE PUBLIC SYNONYM
system privilege.