Getting password for an enabled role in user session

Environment Oracle 8.1.7.3

Trying to get the role password for an enabled role (which was already required by user to enable).

Need this with the enabled existing roles along with a new role.

This string will be sent to dbms_session.set_role( ); e.g. string 'enabledrole1,enabledrole2 identified by <pwd>, newrole'

dba_roles has required_password column. Where is the password kept.?

Looked thru the manual for it.

Process will be run to run is in invoker rights package procedure takes the roletring as argument.
calls dbms_session.set_role(rolestring)

any ideas on how to build up the role string of existing roles enabled.

tia,

dave Fowler
oracle developer/dba Received on Thu Nov 14 2002 - 07:32:29 CST