Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there a way to do this?

Re: Is there a way to do this?

From: Randy Harris <randy.harris_at_nospam.net>
Date: Fri, 09 May 2003 07:19:42 GMT
Message-ID: <iEIua.7097$3f7.4901010@newssvr28.news.prodigy.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US