Re: using set role command in a logon trigger

On 4/4/07, Sriram Kumar <k.sriramkumar_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l