I need to change a user password and then change it back to the original password...

[dcryderm]

I currently have a user I need to login as but is not here to give me his password. I have system priveleges and I believe there is a way to change the password of the user and then change it back again to the original password...anybody know how to do this? Thanks in advance!

[sreddy]

<font face=courier>
spool altuserpwd.sql
SELECT 'ALTER USER '||USERNAME||' IDENTIFIED BY VALUES '||''''||PASSWORD||''''||';'
FROM DBA_USERS
where username in ('XYZ')
/
</font>

[pss]

After that you can
1) change his password for a new one
2) do whatever you wand
3) execute the script to restore the password
4) restard database to let Oracle to use old password.

Sergey.

[marist89]

[QUOTE][i]Originally posted by pss [/i]
[B]
4) restard database to let Oracle to use old password.
[/B][/QUOTE]

You don't have to restart the database, it is done immediately.

[dragon99]

Just a thought, I think when you finish what you have to do,you can just tell the user you have changed his password to perform some necessary job and tell him to change his password to whatever he wants.