where is the public synonym created

[ronnie]

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

[marist89]

The pseudo user PUBLIC owns this synonym.

[ronnie]

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

[marist89]

A synonym doesn't get assigned to a tablespace.

[marist89]

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