Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using ALTER USER <USER> IDENTIFIED BY VALUES (SELECT ?)

User573498-OCJun 9 2015 — edited Jun 9 2015

I'm looking for something similar to an "Alter user <username> identified by values (select spare4 from hash table where name = 'XXX');

I've pulled the hash values for my users and want to revert back to them following a script change that I had to use that reset the user passwords. I've created a table called HASH and pulled the values into that table:

CREATE TABLE HASH

    AS (select name, password, spare4 from sys.user$ where name in ('XXX', 'XXX');


Now I want to revert back to the hash values. How can I pull the hash values and use them to "Alter user <user> identified by values <existing hash values>? - Mike

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2015
Added on Jun 9 2015
4 comments
2,404 views