user$ is updated and why not just reset it to the known value, only if you happen to have the "encrypted" password, then you could set it back using alter user <userid> identified by values 'ENCRYPTED PASSWORD HERE';
otherwise you're outta luck. joe Burton, Laura L. wrote: > When you alter a user's password, what table does it update? > > I need to 'restore' a password for a user back to what it was before I > changed it, but do not know what it was. > > Any ideas?? Can this be done? > > Thanks, > Laura > -- Joe Testa, Oracle DBA Want to have a good time with a bunch of geeks? Check out: http://www.geekcruises.com/standard_interface/future_cruises.html I'm presenting, when registering drop my name :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
