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
