Try creating the synonym as a public synonym. That will give everyone privileges to it without granting them explicitly.
Ruth > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > GovindanK > Sent: Friday, September 05, 2003 4:10 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Problem querying remote table through a synonym > > > Enable Network Tracing and check. > > GovindanK > > > I'm confused, has anyone ever seen something like this before? > > > > This query works as you can see: > > > > select count(*) > > from [EMAIL PROTECTED]; > > > > COUNT(*) > > ---------- > > 275375 > > > > We execute the following DDL: > > > > DROP SYNONYM MV_USER_ENABLED_DOC_TYPE_PRIVS; > > > > CREATE SYNONYM MV_USER_ENABLED_DOC_TYPE_PRIVS > > FOR [EMAIL PROTECTED]; > > > > We run the following query: > > select count(*) > > from mv_user_enabled_doc_type_privs; > > > > The query hangs for over an hour before being killed. When traced it > > shows it is waiting for the other side to respond. > > > > On the other hand, if I do this you can see it works! > > > > 1* select count(*) from [EMAIL PROTECTED] > > SQL> / > > > > COUNT(*) > > ---------- > > 0 > > > > SQL> create synonym mine for [EMAIL PROTECTED]; > > > > Synonym created. > > > > SQL> select count(*) from mine; > > > > COUNT(*) > > ---------- > > 0 > > > > The hanging behavior is true for every table in the markview schema. > >> Allan L. Nelson > >> Oracle DBA > >> M-I L.L.C. > >> (832) 295-2238 office > >> (832) 351-4180 fax > >> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > >> > >> > >> > > > > > __________________________________________________________________ > ____________ > > This email is intended solely for the person or entity to which it is > > addressed and may contain confidential and/or privileged information. > > Copying, forwarding or distributing this message by persons or entities > > other than the addressee is prohibited. If you have received > this email in > > error, please contact the sender immediately and delete the > material from > > any computer. This email may have been monitored for policy compliance. > > [021216] > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: GovindanK > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
