Re: Restrict TOAD from accessing a DB?

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:<JBE9a.658$pK2.1067_at_news.indigo.ie>...
> Probably the ease of browsing ... and the dictionary hits that you'd take
> from the Schema Browse

Ya think? My experience as a DBA with developers wanting to use TOAD in production is that they want to go in and start tweaking application configuration data with no controls. Of course that was in a big place where there were separate designers and developers, and the designers would use Oracle tools to browse the schema. I can see your point though, I've been in smaller places where I might have used TOAD for such a purpose if I didn't write my own scripts and do everything from command line.

> "Joel Garry" <joel-garry_at_home.com> wrote in message
> news:91884734.0303051732.4f72c355_at_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!

jg

--
@home.com is bogus.
"It's a masochists wonderland!"  Radio ad for local ski/snowboard
resort.