Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to stop odbc connections to an oracle database
indiaconsultant1_at_gmail.com wrote:
> Thank you very much. The question is actually stemming from our audit
> and they are asking us if there was a way to disallow all ODBC
> connections. Apparently they have concerns with this.
I don't think you can easily disallow all ODBC connections but you can easily disallow anyone not connecting through an approved tool (provided you don't reveal to users what you are doing so they can circumvent it). Use an AFTER LOGON trigger that checks the program they are running. If not on the approved list ... ALTER SYSTEM KILL SESSION.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Mon Jan 23 2006 - 11:50:59 CST
![]() |
![]() |