Account Locked [message #635752] |
Wed, 08 April 2015 03:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/f57a5ccd1e2d60ed396d8136909b9927?s=64&d=mm&r=g) |
OraGuy21
Messages: 5 Registered: April 2015 Location: India
|
Junior Member |
|
|
Hi Everyone,
While logging into SQL Developer,
am getting the message
'Account Locked'.
Am using hr/hr and how do
I resolve it ?
Thanks and regards,
OraGuy21
|
|
|
|
|
|
|
Re: Account Locked [message #635757 is a reply to message #635756] |
Wed, 08 April 2015 03:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
SQL> alter user hr account lock;
User altered.
SQL> conn hr@pdborcl/hr
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL> conn system@pdborcl
Enter password:
Connected.
SQL> show user
USER is "SYSTEM"
SQL> alter user hr account unlock;
User altered.
SQL> conn hr@pdborcl/hr
Connected.
SQL> show user
USER is "HR"
SQL>
[Updated on: Wed, 08 April 2015 03:54] Report message to a moderator
|
|
|
|
|
|
|
|
|