Re: Getting password for an enabled role in user session

David Fowler wrote:

> 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

When you say "trying to get the role password" do you mean something I'm not getting or do you really think Oracle security is so lax that you can decipher passwords?

Daniel Morgan Received on Thu Nov 14 2002 - 10:58:36 CST