Re: Application role

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 6 Nov 2002 23:04:11 +1000
Message-ID: <dm7y9.70439$g9.200362@newsfeeds.bigpond.com>

Hi Franky,

Yes.

You can assigned a role that contains the required privileges to a user that is only enabled via the application. 9i has some new features regarding how this can be accomplished.

Check out *roles* in the Oracle doco set.

Cheers

Richard
"Franky" <vraag_at_bigfoot.com> wrote in message news:3dc8fb3a$0$73799$ba620e4c_at_news.skynet.be...
> In Sql Server an application role can be created so that users cannot
> connect to the database if they don't use the program.
> In that program you first connect to the database and the exec a stored
> procedure using a password. Then you can select, delete, update the
records
> in the database. If you use another tool (MsAccess, Query analyzer, ...)
you
> cannot select, delete and update the records.
>
> Can you create the same in Oracle 8i or 9i?
>
>
> Thanks for the answers,
>
>
> Franky
>
>
Received on Wed Nov 06 2002 - 07:04:11 CST