Re: using set role command in a logon trigger
- From: "Paul Drake" <bdbafh@xxxxxxxxx>
- To: k.sriramkumar@xxxxxxxxx
- Date: Fri, 6 Apr 2007 12:42:08 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
