Re: Block connection from SQL developer

Dear Experts ,

we dont want to enforce it from the database end , in fact we don't want to touch anything from DB side , any setting from SQL developer or other parameters apart from DB end would help here .

Regards,
Krishna

On Fri, 11 Mar 2022 at 17:53, John Thomas <jt2354_at_gmail.com> wrote:

> 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