Re: Recreating roles with passwords

Look at the definition of dba_roles view

select name, decode(password, null, 'NO', 'EXTERNAL', 'EXTERNAL','GLOBAL', 'GLOBAL', 'YES')
from user$
where type# = 0 and name not in ('PUBLIC', '_NEXT_USER')

It seems that the roles are stored in user$ table along with the users with type#=0
type#=1 is for the users.
But the role password is not exposed via any view. So maybe you can go against user$ table itself or create your own view exposing the role passwords also

amit

Don Seiler wrote:
> I'm writing a little perl script to migrate users and roles to another
> server. Some of the roles have passwords, but I can't find the
> passwords. The dba_users view, for example, gives me the encrypted
> value of the user's password so that I can build my CREATE USER sql
> statement with IDENTIFIED BY VALUES. Does anyone know where, if
> anywhere, I can find the password for a role so that I can recreate
> it?
>
>

--
http://www.freelists.org/webpage/oracle-l