Re: using set role command in a logon trigger

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