Re: Block connection from SQL developer
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 12 Mar 2022 02:43:52 -0500
Message-ID: <1bc2584c-6eb8-e4cc-cd53-2726888dd737_at_gmail.com>
Date: Sat, 12 Mar 2022 02:43:52 -0500
Message-ID: <1bc2584c-6eb8-e4cc-cd53-2726888dd737_at_gmail.com>
On 3/11/22 07:23, John Thomas wrote:
You could have a database logon trigger that raises an error if the user's V$SESSION.PROGRAM is SQL Developer.
You can be creative with the errors you rise. My favorite is
ORA-7445. It scares bejezus out of people trying to connect. Or
you can ask the questions three for the other side of database
connection to see.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com-- http://www.freelists.org/webpage/oracle-l Received on Sat Mar 12 2022 - 08:43:52 CET