Re: Trap ODBC connections?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/09/25
Message-ID: <01bcc9a7$96d082a0$ba030059@billyv.vslabs.co.za>#1/1

Cyrus AU YEUNG <cyrus_at_net.polyu.edu.hk> wrote in article <34291F80.1F1F3024_at_net.polyu.edu.hk>...
> Dear all experts,
>
> May I know is it possible to trap/stop all ODBC connections to an
> Oracle 7 database? I want to make SQL*NET is the only way to connect to
> the database.

I don't think there is. What you can do is the following. Run a select on v$session and terminate any sessions using an invalid program to connect.

SELECT
'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||'''' FROM v$session
WHERE program = 'Visual Basic 4.0';

Write this to a spool file and run the spool file. You can even cron it and let it run every few minutes or so.

regards,
Billy Received on Thu Sep 25 1997 - 00:00:00 CDT