Xref: alice comp.databases.oracle.server:73571
Path: alice!news-feed.fnsi.net!news.idt.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: Nandakumar <N.Kumar@rocketmail.com>
Newsgroups: comp.databases.oracle.server
Subject: dba question - synonym
Date: Thu, 11 Nov 1999 17:42:12 GMT
Organization: Deja.com - Before you buy.
Lines: 16
Message-ID: <80ev5i$3u2$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Nov 11 17:42:12 1999 GMT
X-Http-User-Agent: Mozilla/4.51 [en] (WinNT; I)
X-Http-Proxy: 1.0 x27.deja.com:80 (Squid/1.1.22) for client 209.117.251.206
X-MyDeja-Info: XMYDJUIDnanban



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.