Re: changing password and back again

"Arno Bouwman" <arno_at_the-bouwmans.demon.nl> wrote in message news:<u0kur04adj7l2a_at_corp.supernews.com>...
> 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.

You can't *update* an user, you can only *alter* it. Replace the keyword update by alter.
You also should use
' identified by values '''||password||''';'

Hth
Sybrand Bakker
Senior Oracle DBA Received on Mon Dec 03 2001 - 07:47:41 CST