Re: Intersolv ODBC Driver and Synonyms
From: Gary Johnson <BLACKHAWK_at_email.msn.com>
Date: 1997/09/05
Message-ID: <01bcb9cb$aff06c00$482d2299_at_blackhawk>#1/1
Date: 1997/09/05
Message-ID: <01bcb9cb$aff06c00$482d2299_at_blackhawk>#1/1
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>...Received on Fri Sep 05 1997 - 00:00:00 CEST
> 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 :-)
>