Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: using set role command in a logon trigger

Re: using set role command in a logon trigger

From: Paul Drake <bdbafh_at_gmail.com>
Date: Fri, 6 Apr 2007 12:42:08 -0400
Message-ID: <910046b40704060942m24e3646sed4542b4a00e6624@mail.gmail.com>


On 4/6/07, Sriram Kumar <k.sriramkumar_at_gmail.com> wrote:
> Hi Jared,

> My mistake. Thanks for pointing out the same.

> My undestanding of the requirement was to allow/disallow a role if the user
> is connected from a particular node/app and this can be implemented using
> roles authenticated using packages and if we use this approach, triggers are
> NOT required

> have not tried myself by example seems to match Laura's requirement

> Refer Creating Secure Application Roles under
> http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14266/apdvntro.htm

> I dont have access to a DB to test by looks like the approach would work

> Best Regards

> Sriram Kumar

Sriram,

I would be careful about its use.
Recent versions of RDA show rows in dba_feature_usage for this, which may or may not be included as part of standard edition or standard one.
This could cause a licensing issue, but I am not a lawyer nor an Oracle sales rep.

Paul

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 06 2007 - 11:42:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US