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

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to stop odbc connections to an oracle database

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

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 23 Jan 2006 18:43:40 GMT
Message-Id: <pan.2006.01.23.18.43.40.480409@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


Received on Mon Jan 23 2006 - 12:43:40 CST












Original text of this message













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