Re: granting role in application
From: Joost Bataille <bataille_at_ic.uva.nl>
Date: Thu, 15 Feb 2001 09:37:54 +0100
Message-ID: <96g4eb$guk$1_at_mail.ic.uva.nl>
Date: Thu, 15 Feb 2001 09:37:54 +0100
Message-ID: <96g4eb$guk$1_at_mail.ic.uva.nl>
[Quoted] "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 Thu Feb 15 2001 - 09:37:54 CET