Need Help - VB/Oracle Synonyms
From: Robert Zarazowski <zarazowr_at_equity.wharton.upenn.edu>
Date: 1996/06/24
Message-ID: <4qn5ro$qjh_at_netnews.upenn.edu>#1/1
Received on Mon Jun 24 1996 - 00:00:00 CEST
Date: 1996/06/24
Message-ID: <4qn5ro$qjh_at_netnews.upenn.edu>#1/1
Help!
I'm creating an application using VB 4.0 (16-bit) connecting to an Oracle 7.3 database. I want to use Oracle "synonyms" to point to different views (so that different users see different subsets of data while using the same SQL).
Does VB allow me to do this.... no!
Running the code as the table owner, things are fine... I can update using bound controls. When running as Josephine User, I cannot read the data using the synonym... but I cannot update.
Am I approaching this wrong? Is there a "better" way to achieve user-based security using Oracle that VB *can* handle?
Thanks in advance for any light that anyone can shine my way.
Bob Zarazowski
Received on Mon Jun 24 1996 - 00:00:00 CEST