Re: using set role command in a logon trigger

Hi Paul,

Point noted. Thanks

Best Regards

Sriram Kumar


On 4/6/07, Paul Drake <bdbafh@xxxxxxxxx> wrote:

On 4/6/07, Sriram Kumar <k.sriramkumar@xxxxxxxxx> 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

Other related posts: