Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dba question - synonym
There is not.
It is however very easy to create a script to do this for all tables in your
schema.
Hth,
--
Sybrand Bakker, Oracle DBA
Nandakumar <N.Kumar_at_rocketmail.com> wrote in message
news:80ev5i$3u2$1_at_nnrp1.deja.com...
>
>
> this is related to synonym ...
>
> i wonder if there is a way to create a PUBLIC synonym for every table on
> its creation.
>
> say, when a table TABLE_A is created by user USER_A, there should a
> PUBLIC synonym TABLE_A be created with link to USER_A.TABLE_A.
>
> Thanks for your responses.
> Nandakumar
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Thu Nov 11 1999 - 12:46:34 CST