You could also consider removing the CONNECT privilege and regranting it
when the conversion is done
"Andrew Allen" <ajallen_at_mailhost.det.ameritech.net> wrote in message
news:3C129B75.CC749718_at_mailhost.det.ameritech.net...
> 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
Received on Sat Dec 08 2001 - 22:47:12 CST
