Re: Public Tables

Create a public synonym

create public synonym client from john.client;

vanzyl_at_my-dejanews.com wrote in message <7dn9la$ht2$1_at_nnrp1.dejanews.com>...
>Hi
>
>I am new to Oracle and would like to know how to create a public table, so
>that all the users can refer to it as : select * from client instead of:
>select * from john.client I know you can create this table under the sys
>account but I would rather create a public table if possible.
>
>Please Help
>
>Jaco van Zyl
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Mar 29 1999 - 01:54:44 CST