Re: ´ð¸´: how to ban plsql developer connect to oracle
Date: Thu, 18 Mar 2010 15:06:56 +0000
This works well for my case
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
> 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
> > The plsql developer search widget may cause some ora-600 warning in
> > 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).
> 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
> a last resort. And it doesn't always send the right message to your
> co-workers, but every situation is different.
> HTH! GL!
-- 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-lReceived on Thu Mar 18 2010 - 10:06:56 CDT