RE: create user with existing password
Date: Fri, 4 Mar 2011 13:47:45 -0500
I am sure this works. I have/had a script to 'become_u'. which essentially saves off the encrypted password using a values clause sql statement as shown below, then changes the password to something simple, logs in, and then executes the saved statement and deletes the saved statement.
It started to generate alert log errors, I believe ora-0600 in 11g databases. An analyst at metalink said it was never supported or documented.... (surprise to me since I used it since oracle 8). So... they started talking about proxy users and such... (just more complication), but the bottom line is, you might expect to see some errors show up...
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TJ Kiernan Sent: Friday, March 04, 2011 12:31 PM
To: pdba1966_at_hotmail.com; oracle-l_at_freelists.org Cc: TJ Kiernan
Subject: RE: create user with existing password
Since password are hashed, this will take some fancy footwork. I haven't tried this, but the approach seems like a decent candidate (unless the hashing algos change between versions).
The information contained in this message is privileged and confidential information intended only for the use of the individual or entity identified above. If the receiver of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, use or copying of this message is strictly prohibited. If you have received this message in error, please immediately notify the sender by replying to his/her e-mail address noted above and delete the original message, including any attachments. Thank you.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of P D
Sent: Friday, March 04, 2011 11:08 AM
Subject: create user with existing password
Does anybody have a dynamic sql script that pulls user definitions (including current passwords) into a text file? I need to move users from a 10g database over to an 11g database. They want to keep their current passwords.Received on Fri Mar 04 2011 - 12:47:45 CST