Re: changing password and back again

Why not save the hashed password into a save table, set your value,
update from the save table

Recommend testing with a junk account.

Arno Bouwman (arno_at_the-bouwmans.demon.nl) wrote:
: Hello,

: I would like to change certain user's passwords to prevent them from
: connecting during an euro-conversion. And change them back to their original
: passwords afterwards.

: I've done this in the past something like this:

: spool reset.sql
: select 'update user '||username||' identified by '||password||';' from
: dba_users where user in ('USER1','USER2');
: spool off
: than change the password so they can not connect any more
: do the job
: start reset.sql

: I can't get it to work any more ..... anybody knows how to???????????

: Arno.

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.