Re: Is it possible to stop odbc connections to an oracle database

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 23 Jan 2006 20:17:19 -0500
Message-ID: <nsSdnRvyipy7HUjeRVn-hA@comcast.com>

"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message news:pan.2006.01.23.18.43.40.480409_at_sbcglobal.net...
> On Mon, 23 Jan 2006 07:27:32 -0800, indiaconsultant1 wrote:
>
>> Is it possible to stop odbc connections to an oracle database? Is there
>> a setting at the Oracle database server level that lets it refuse odbc
>> connections? Any ideas?
>>
>> Thank you
>
> SQL> alter system enable restricted session;
>
> System altered.
>
> That will stop ODBC and all other connections if the user
> doesn't have "restricted session" privilege, which is usually
> the case.
>
> --
> http://www.mgogala.com
>

Tbe key phrase here is "and all other connections"

I don't think this really addresses the OP's situation -- not quite as extreme as shutting down the database, but basically along the same lines ;-)

++ mcs Received on Mon Jan 23 2006 - 19:17:19 CST