Re: Limiting DB Access to 1 Application

From: Niall Litchfield <Niall.Litchfield_at_btinternet.com>
Date: Fri, 21 Sep 2001 07:57:03 +0100
Message-ID: <9oenv3$9ve$1@uranium.btinternet.com>

Actually that is not (necessarily) true. v$session will tell you the program being used to access the instance.

with 8i you have database event triggers so I would imagine a way to do this would be to fire a trigger on logon that checked v$session for the program name and kicked the user if it was app B.

The only problem I can see is that sometimes I find that program appears null in v$session.

Niall
"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:
>
> > If you grant access priviledges to a user or role so that
> > person can use application A to change the DB, how do you stop
> > that same user from using application B
>
> 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.
Received on Fri Sep 21 2001 - 01:57:03 CDT