RE: create user with existing password
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <tkiernan@xxxxxxxxxxx>, <pdba1966@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- 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...
Joel Patterson
Database Administrator
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of TJ Kiernan
Sent: Friday, March 04, 2011 12:31 PM
To: pdba1966@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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).
Thanks,
T. J.
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of P D
Sent: Friday, March 04, 2011 11:08 AM
To: oracle-l@xxxxxxxxxxxxx
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.
Other related posts:
