Re: 答复: how to ban plsql developer connect to oracle
- From: "A. Coskan Gundogar" <gundogar@xxxxxxxxx>
- To: maclean_007@xxxxxxx
- Date: Thu, 18 Mar 2010 15:06:56 +0000
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@xxxxxxx>
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> 代表 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Coskan GUNDOGAR
Oracle DBA
Email: gundogar@xxxxxxxxx
Blog: http://coskan.wordpress.com
Twitter: http://www.twitter.com/coskan
Linkedin: http://uk.linkedin.com/in/coskan
Other related posts:
