Xref: alice comp.databases.oracle.server:35801
Newsgroups: comp.databases.oracle.server
Path: alice!news-feed.fnsi.net!netnews.com!news.idt.net!newsfeed.cwix.com!194.162.162.196!newsfeed.nacamar.de!peer.news.nildram.co.uk!peernews.cix.co.uk!cix.compulink.co.uk!usenet
From: dlane@cix.compulink.co.uk ("David Lane")
Subject: Re: Prevent use ODBC to connect Oracle Engine
Message-ID: <F3vCEx.FHq@cix.compulink.co.uk>
Organization: Compulink Information eXchange
References: <74kvqh$cnh$1@news.seed.net.tw>
Date: Sat, 12 Dec 1998 20:18:33 GMT
Lines: 21

In article <74kvqh$cnh$1@news.seed.net.tw>, btzeng@ms1.hinet.net (Bill) 
wrote:

> Hi,
>       For security concern, does anyone  have the experience that :
> How can I config the DB to prevent user connect to Oracle DB on Unix by 
> ODBC
> ?
> (I prefer user using sql*net client only !!)
> 
> Thanks.
> 
> 
> 

We've set up roles which we intend to put passwords on later. We'll then 
provided a routine which 'approved' applications can access to switch to 
the role on login. This means that unapproved applications will be able to 
login, but not do anthing .... perhaps this would work for you too.

Dave Lane (dlane@pt.lu)