Re: using set role command in a logon trigger - oracle-l - FreeLists

Re: using set role command in a logon trigger

From: "Jared Still" <jkstill@xxxxxxxxx>
To: k.sriramkumar@xxxxxxxxx
Date: Thu, 5 Apr 2007 18:21:54 -0700

On 4/4/07, Sriram Kumar <k.sriramkumar@xxxxxxxxx> wrote:


Hi,

There is this new feature in 10g that allows you to authenticate roles
based on packages. You can use that feature for this situation of yours.

create role <> identified using schema.package;


Actually that was new in 9i.  :)

I was playing with it on 9.2.0.7 just this morning.

It still doesn't work from a trigger however.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Follow-Ups:
- Re: using set role command in a logon trigger
  - From: Sriram Kumar

References:
- using set role command in a logon trigger
  - From: laura pena
- Re: using set role command in a logon trigger
  - From: Sriram Kumar

Other related posts:

» using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger
» Re: using set role command in a logon trigger