Re: Security: only specific app allowed for userid?

From: Nobody <Nobody_at_yahoo.com>
Date: Wed, 20 Oct 1999 13:29:57 +0800
Message-ID: <380d5335@ruby.hknet.com>

Try if this work.

(1) create a db role with will access all db tables, view, etc
(2) grant this role to the only db userid you have but DISABLE it by default
(3) after user login via your appl, grant this role to the userid.  this

role will be disabled when user logout

in this case, the same userid login to sqlplus will not be able to access any db tables.

pls let know if this works.

Toni Häkkänen <toni.hakkanen_at_upm-kymmene.com> wrote in message news:IjcP3.6$7A2.623_at_read2.inet.fi...
> Hello,
> Is there a way to restrict (by oracle's means) users login
> only to a certain application?
>
> We have about 300 users using the _same userid_ for db login,
> and we would like to keep SQL*Plus ond other "not authorized"
> apps away from db.
>
> We are using 7.3.4 and Net2.
>
> If you have other better means to handle this kind of problem,
> please share you knowledge... However, i'm not going to start
> supporting 300 userids and pwds in oracle.
>
> Cheers,
> Toni Häkkänen
>
>
Received on Wed Oct 20 1999 - 00:29:57 CDT