Re: : how to ban plsql developer connect to oracle

From: A. Coskan Gundogar <gundogar_at_gmail.com>
Date: Thu, 18 Mar 2010 15:06:56 +0000
Message-ID: <d1f742de1003180806r2dbf5f3cu5bcd02bbda66bfbf_at_mail.gmail.com>



This works well for my case

http://damir-vadas.blogspot.com/2010/01/how-to-prevent-sqlplus-acces-to.html

<http://damir-vadas.blogspot.com/2010/01/how-to-prevent-sqlplus-acces-to.html> Regards

2010/3/18 maclean <maclean_007_at_163.com>

> Thx a lot . Actually I wonder if exists any natural feature in oracle can
> do this.
> In my experience ,Plsql developer search widget may cause ora-600 warning
> in
> any version including 10.2.0.4.
> And the developers are so adamancy to use plsql developer.
> -----ʼԭ-----
> : oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> Rich Jesse
> ʱ: Thursday, March 18, 2010 11:05 AM
> ռ: 'Oracle-L Freelists'
> : Re: how to ban plsql developer connect to oracle
>
> > Anyone can advise how to ban plsql developer connect to
> oracle?
> > The plsql developer search widget may cause some ora-600 warning in
> alert
> > log . So I want to ban any connection using plsql developer.
>
> You don't say what versions or platforms of either DB nor client, so I'll
> give generic advice.
>
> -- It's causing ORA-600 problems in the DB? Fix them.
> -- Take the high road and explain the situation with developer(s).
> Perhaps
> an explanation to their manager and provide an alternate solution as well.
> I'd suggest Toad for Oracle, but that's just me. :)
> -- If all else fails, check V$PROCESS to see if a logon trigger could be
> applied using perhaps the MODULE or PROGRAM columns.
>
> The trigger may be able to be circumvented by a crafty Dev, so I'd use it
> as
> a last resort. And it doesn't always send the right message to your
> co-workers, but every situation is different.
>
> HTH! GL!
>
> Rich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Coskan GUNDOGAR

Oracle DBA

Email: gundogar_at_gmail.com
Blog: http://coskan.wordpress.com
Twitter: http://www.twitter.com/coskan
Linkedin: http://uk.linkedin.com/in/coskan

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 18 2010 - 10:06:56 CDT

Original text of this message