Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to unlock user SCOTT
Thanks for the quick response Hans!
Worked great.
Have another question you may be able to answer.
I believe in 8i the windows version had some kind of application to do a variety of things such as user maintenance, alter tables etc..
Do you know if 9i or 10g have some sort of thing or am I thinking of a third party application?
Thanks again.
"HansF" <News.Hans_at_telus.net> wrote in message
news:pan.2005.11.13.18.17.56.409442_at_telus.net...
> As a DBA (for example SYSTEM), in SQLPlus
>
> alter user scott account unlock;
>
> --
> Hans Forbrich
> Canada-wide Oracle training and consulting
> mailto: Fuzzy.GreyBeard_at_gmail.com
> *** Top posting relies guarantees I won't respond. ***
>
Received on Sun Nov 13 2005 - 14:49:43 CST