Re: Question regarding roles
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 7 Feb 2004 13:36:25 +0200
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@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, February 07, 2004 11:39 AM
Subject: Re: Question regarding roles
> Darn!
>
> Cheers
> Nuno Souto
> in sunny Sydney, Australia
> dbvision@xxxxxxxxxxxxxxx
> ----- Original Message -----
> From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
>
>
> > 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
