Recreating roles with passwords

  • From: "Don Seiler" <don@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Aug 2007 11:09:54 -0500

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: