Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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.netReceived on Sat Dec 08 2001 - 17:00:19 CST
![]() |
![]() |