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