Home » RDBMS Server » Security » login issue (oracle 9i / Win XP)
login issue [message #431672] Thu, 19 November 2009 01:23 Go to next message
Babul
Messages: 2
Registered: November 2009
Location: Imphal
Junior Member
Hi,
I am using Oracle 9i. i wish to access user hr but it says it's lock how do i unlock it.
please find me a solution.
Re: login issue [message #431677 is a reply to message #431672] Thu, 19 November 2009 02:02 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Connect as a privileged user and unlock the account:
SQL> alter user hr account unlock;

User altered.

SQL>

[Updated on: Thu, 19 November 2009 02:03]

Report message to a moderator

Previous Topic: cannot logging as sysdba
Next Topic: grant privilege to use for a table
Goto Forum:
  


Current Time: Fri Mar 29 05:46:28 CDT 2024