Re: Question regarding roles

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Sat, 7 Feb 2004 13:36:25 +0200
Message-ID: <30b501c3ed6e$9edffa10$eafb23d5@porgand>

Sorry Nuno, I didn't read your question carefully enough at first. As Jacques said, you can't read active role information for other sessions with regular methods, since this is session's private info.

However, depending what you want to do, you could use secure application roles and global contexts for achieving your goal. You define all your roles authenticated by a package - that way only this package can set the role for any session. And when the package sets the role, it also updates the corresponding clients global context attributes, which are globally readable within an instance.

Tanel.

Original Message ----- From: "Nuno Souto" <dbvision_at_optusnet.com.au> To: <oracle-l_at_freelists.org> Sent: Saturday, February 07, 2004 11:39 AM Subject: Re: Question regarding roles

> Darn!
>
> Cheers
> Nuno Souto
> in sunny Sydney, Australia
> dbvision_at_optusnet.com.au
> ----- Original Message -----
> From: "Jacques Kilchoer" <Jacques.Kilchoer_at_quest.com>
>
>
> > There's no way to tell which roles are currently enabled in another =
> > session.
> >
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sat Feb 07 2004 - 05:36:25 CST