soccer_champ

• Jun 18th, 2005

 

A private synonym is owned by a specific user who has control over its availability to others.  
In case of doubt, contact me : bobby_1020@hotmail.com

Dan

• Jul 9th, 2005

 

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. 
 
To create a PUBLIC synonym, you must have CREATE PUBLIC SYNONYM system privilege. 
 
Use the CREATE SYNONYM statement to create a synonym, which is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object, user-defined object type, or another synonym. 
 
Synonyms provide both data independence and location transparency. Synonyms permit applications to function without modification regardless of which user owns the table or view and regardless of which database holds the table or view. However, synonyms are not a substitute for privileges on database objects. Such privileges must be granted to a user before the user can use the synonym. 
 
 

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh 

• Apr 7th, 2009

 

private synonym is a synonym which resides in the owners schema