Re: granting role in application

Here is an article that includes the details of what you need to do: http://www.summitsoftwaredesign.com/articles/article9.html

Joost Bataille <bataille_at_ic.uva.nl> wrote in message news:96g4eb$guk$1_at_mail.ic.uva.nl...
>
> "John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote
> > Look at the dbms_session package. You can use
 dbms_session.is_role_enabled
> > to see if the user already has that role enabled. If not, you can use
> > dbms_session.set_role to enable the role for the session.
> > If you really want to make it bullet-proof, you can grant the
 non-default
> > role with password protection. That way the user can't enable the role
> > himself in SQL*Plus.
>
> Thanks, John. This is what I was looking for.
> Joost
>
>
>
Received on Fri Feb 16 2001 - 03:25:53 CET