Re: How to determine in PL/SQL if a user has a certain role?

Mike wrote:

> You can get all roles in database:
> select * from sys.user$ where type#=0;
> Creating function with this kind of query is simple.

Thanks for the tip, Mike, sounds promising. Does the current user need any special privilege to select from the sys.user$ table?

Regards,
Holger.

-- 
Dr. Holger Peine
Fraunhofer IESE, Kaiserslautern, Germany
Phone +49-6301-707-134, Fax -200 (shared)
www.iese.fraunhofer.de/Staff/peine -- PGP key on request or via pgp.mit.edu