where is the public synonym created

Hi,

Under which schema and tablespace is the public synonym created when you give a command like this


create public synonym test for test;

you are issuing this command who owns test;

Thanks
Ronnie

The pseudo user PUBLIC owns this synonym.

and where does this Pseudo user reside. I mean which tablespace and what are the characteristics of this user....

How much control I as a DBA can have on this pseudo user

A synonym doesn't get assigned to a tablespace.

See http://otn.oracle.com/docs/products/...5acces.htm#647 for details.