Re: changing password and back again

Arno Bouwman 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.

How about
SQL> alter user <uername> account lock;

then when you are ready to allow them access again: SQL> alter user <username> account unlock;

-- 
Andrew Allen
Livonia, MI
E- Mailto:ajalle_at_ameritech.net