Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to unlock user SCOTT

Re: How to unlock user SCOTT

From: -Alex <NoSpam_at_nospam.com>
Date: Sun, 13 Nov 2005 20:49:43 GMT
Message-ID: <HFNdf.12976$cg.1130@news02.roc.ny>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US