Re: Intersolv ODBC Driver and Synonyms

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    :-)