Re: Application role

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 9 Nov 2002 16:57:14 +1100
Message-ID: <Lk1z9.72668$g9.205561@newsfeeds.bigpond.com>

Yes, it's one of the new features of 9i (only).

It works exactly as you describe.

Create role blah identified using my_procedure;

Regards
HJR "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 Fri Nov 08 2002 - 23:57:14 CST