Re: Block connection from SQL developer

You could have a database logon trigger that raises an error if the user's V$SESSION.PROGRAM is SQL Developer.

Depends on your requirement though. If you have privileged users with other means of access - SQL*Plus for instance - they could easily disable the trigger.

Regards,

John Thomas

On Fri, 11 Mar 2022 at 12:08, Krishnaprasad Yadav <chrishna0007_at_gmail.com> wrote:

> Dear Gurus,
>
> We are in a requirement that certain database instances should not
> connect from sql developer.
> incase of 40 Database we can connect 36 by sql developer and remaining 4
> database should not connect by SQL developer .
>
> Is their any sort of Setting or any other alternative available in SQL
> developer .
>
>
> Regards,
> Krishna
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l