Re: Trap ODBC connections?
From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/09/25
Message-ID: <01bcc9a7$96d082a0$ba030059_at_billyv.vslabs.co.za>#1/1
Date: 1997/09/25
Message-ID: <01bcc9a7$96d082a0$ba030059_at_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 CEST