Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restrict TOAD from accessing a DB?
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