Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to trap the user's login program and disallow if Windows based?
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