Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Restrict TOAD from accessing a DB?

Re: Restrict TOAD from accessing a DB?

From: Joel Garry <joel-garry_at_home.com>
Date: 5 Mar 2003 17:32:44 -0800
Message-ID: <91884734.0303051732.4f72c355@posting.google.com>


navaed7024_at_hotmail.com (E. Navarro) wrote in message news:<b86354ef.0303051201.34b7908e_at_posting.google.com>...
> Oracle EE 8.1.7.4
> Sun OS 5.7

Apologies if this is posted twice, google suddenly did weird things a few minutes ago.
>
>
> All,
>
> Does anyone know of a solution to prevent users from logging into a
> database with certain applications. In my case, I want to prevent users
> from logging into our production databases using TOAD.
>
> I can monitor who is logging in and how they are logging in using OEM,
> but what I would like is to be alerted the second someone tries to log
> in using TOAD. Can this be done?

If you have listener logging turned on, you might write a little shell script that does a tail -f on the log and parse out the PROGRAM= statement. Then parse out the ip address and ping flood them until you can get your silver hammer or they complain how slow the system is. :-O

So what is it they can do with toad that they can't do with anything else? Sounds like you need better password control.

jg

--
@home.com is bogus.
I wuz only kidding!  Honest!
Received on Wed Mar 05 2003 - 19:32:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US