I was expecting Tanel to say "I have a little program that reads the UGA = for a session and shows you which roles are enabled." :-) > -----Original Message----- > Tanel P=F5der >=20 > Sorry Nuno, I didn't read your question carefully enough at first. As > Jacques said, you can't read active role information for=20 > other sessions with > regular methods, since this is session's private info. >=20 > However, depending what you want to do, you could use secure=20 > application > roles and global contexts for achieving your goal. > You define all your roles authenticated by a package - that=20 > way only this > package can set the role for any session. And when the=20 > package sets the > role, it also updates the corresponding clients global=20 > context attributes, > which are globally readable within an instance. ---------------------------------------------------------------- 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 -----------------------------------------------------------------