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_at_gmail.com> wrote:
>
> 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