Re: Recreating roles with passwords
- From: jherrick@xxxxxxx
- To: don@xxxxxxxxx
- Date: Wed, 15 Aug 2007 12:56:51 -0400
look in sys.user$ where TYPE# = 0 (regular user passwords are Type 1)
JH
Quoting Don Seiler <don@xxxxxxxxx>:
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
- References:
- Recreating roles with passwords
- From: Don Seiler
Other related posts:
- » Recreating roles with passwords
- » Re: Recreating roles with passwords
- » Re: Recreating roles with passwords
- » Re: Recreating roles with passwords
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
- Recreating roles with passwords
- From: Don Seiler