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: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 13 Nov 2005 13:57:06 -0800
Message-ID: <1131919106.924164@yasure>


-Alex wrote:
> 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. ***

  1. Please stop top posting
  2. Oracle Enterprise Manager (OEM)
-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Nov 13 2005 - 15:57:06 CST

Original text of this message

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