Re: using set role command in a logon trigger

  • From: "Sriram Kumar" <k.sriramkumar@xxxxxxxxx>
  • To: "Paul Drake" <bdbafh@xxxxxxxxx>
  • Date: Sat, 7 Apr 2007 02:08:32 +0530

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
> is connected from a particular node/app and this can be implemented
> roles authenticated using packages and if we use this approach, triggers
> NOT required

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

> Refer Creating Secure Application Roles under

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

> Best Regards

> Sriram Kumar


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
This could cause a licensing issue, but I am not a lawyer nor an
Oracle sales rep.


Other related posts: