Re: Recreating roles with passwords

look in sys.user$ where TYPE# = 0 (regular user passwords are Type 1)

JH

Quoting Don Seiler <don_at_seiler.us>:

> 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?
>
> --
> Don Seiler
> oracle: http://ora.seiler.us
> ultimate: http://www.mufc.us
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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