Re: how to ban plsql developer connect to oracle
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Wed, 17 Mar 2010 22:05:03 -0500 (CDT)
Message-ID: <5f29d83080125bd43d49e58dca158e57.squirrel_at_society.servebeer.com>
> 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.
Date: Wed, 17 Mar 2010 22:05:03 -0500 (CDT)
Message-ID: <5f29d83080125bd43d49e58dca158e57.squirrel_at_society.servebeer.com>
> 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-lReceived on Wed Mar 17 2010 - 22:05:03 CDT