Re: Limiting DB Access to 1 Application

From: Peter Kallweit <kallweit_at_iief.de>
Date: Fri, 21 Sep 2001 14:43:06 +0200
Message-ID: <3BAB35DA.8FF609C7@iief.de>

Niall Litchfield wrote:
>
> Actually that is not (necessarily) true. v$session will tell you the program
> being used to access the instance.
>
>
> "Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
> news:uadzp87eb.fsf_at_verizon.net...
> > On 20 Sep 2001, chrish57_at_my-deja.com wrote:
> >

> >
> > Oracle won't know anything about the application that is
> > accessing it. It will only know the user. Maybe App B can check
> > the username upon login and not allow certain users access.
> > --
> > Galen Boyer
> > It seems to me, I remember every single thing I know.

V$SESSION will not always tell you the application name. It only does if the application provides its name. When I connect with my java application, oracle just tells 'JDBC THIN CLIENT'. Peter Received on Fri Sep 21 2001 - 07:43:06 CDT