|
|
|
|
|
Re: Account Locked [message #635757 is a reply to message #635756] |
Wed, 08 April 2015 03:43   |
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
|
|
|
|
|
|
|
|
|