Re: Intersolv ODBC Driver and Synonyms

I too have used Synonyms in VB4 with the Intersolve driver without any problems. Make sure that you have granted the user select privileges on the views that the synonyms are created on.

IE:
Grant Select on V_Customer to JohnDoe;

Create Synonym S_Customer for JohnDoe.V_Customer;

I Hope this helps!

Gary

-- 
Blackhawk_at_MSN.Com
GERJOH_at_HBSI.COM



Matthias Gresz <GreMa_at_t-online.de> wrote in article
<5t1nuc$oro$1_at_news00.btx.dtag.de>...


> Brad Murray wrote:

> > 

> > We are developing a VB5 app using the Intersolv ODBC driver and Oracle

 7.3.


> > We recently had to go to a new complex security system using a series

 of


> > private synonyms to views for each user.  Now that I have reworked all

 of the


> > code to handle the new layout we are getting insufficient privilege

 errors on


> > all accesses while there are no problems selecting from the synonyms in

 SQL


> > worksheet.  My best guess is that the Intersolv driver does not support

> > synonyms.  Can anybody confirm or refute that?

> > 

> > If you have a good solution I will gladly pay you for your time.

> > 

> > PS - Please respond by mail as well as to the group.

> > 

> > Brad

> > 

> > _______________________________________________________________________

> >  Bradley S. Murray       Princeton Computer Consulting  (609) 730-9100

> >  BradMurray(-at-)usa.net   Pennington, NJ 08534-3612    Fax:  275-5651

> > 

> > To respond, use the address in the signature and while you're at it,

> > dummy up your reply address to avoid getting junk e-mail from these

> > scum bags who scan newsgroups to build address lists

> > 

> > Support the anti-Spam amendment - Join at http://www.cauce.org/

> Hi,

> 

> 

> you can use synonyms (we used with VB3).  When you've declared public

> synonym you can easyly use them. Just write them in capital laetters. To

> acces non-public-synonyms you've got to specify the shema.

> -- 

> Regards

> 

> M.Gresz    :-)

>