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: How to trap the user's login program and disallow if Windows based?

Re: How to trap the user's login program and disallow if Windows based?

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 4 Jun 2002 23:22:56 -0700
Message-ID: <1e8276d6.0206042222.591bdf42@posting.google.com>


Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CFD4DC6.5E5D917B_at_exesolutions.com>...
> Andy wrote:
>
> > Oracle RDBMS V8.0.6 on Solaris 2.7
> >
> > I can remember that there is a way to trap the program name a user is
> > logging into the database with, and disallow it if it is something
> > like TOAD or ACCESS.
> Use a logon SYSTEM trigger and take a look in v_$session.

This will not help him. His primary problem is badly written application and there is no way to correct this without rewriting application.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Wed Jun 05 2002 - 01:22:56 CDT

Original text of this message

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