Sean, AFAIK there is no way to stop a user from connecting if they have a
valid login in the database. The way that I have approached the problem is,
yes I give them an Oracle login but they have no permissions other than
create session. The account that actually has permission to access any data
or create anything in Oracle is embedded in my application. So, I use the
Oracle login simply to authenticate the user, but he can do nothing without
the application. It's been running this way for a couple of years now,
currently there are about 80 users. So far so good.
--
Randy Harris
"Sean" <seanm1_at_sisna.com> wrote in message
news:6cdbf986.0305082152.2e0479cb_at_posting.google.com...
> Hello all,
> I'm a VB developer that uses Oracle 8i. Is there a way to deny an
> ODBC connection to the database if the user is not using the VB
> program to access it? I'm having trouble making sure users are
> connecting to the Oracle data via my program and not another program
> (like SQL+, etc.).
>
> Is there a way to set up a token in the connection string that would
> authenticate the program's connection request to Oracle? I'm not an
> Oracle expert and would not know the answer to this. Thanks,
>
> Sean McElroy
Received on Fri May 09 2003 - 02:19:42 CDT
