Home » RDBMS Server » Security » login issue (oracle 9i / Win XP)
login issue [message #431672] Thu, 19 November 2009 01:23 Go to next message
Messages: 2
Registered: November 2009
Location: Imphal
Junior Member
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
Messages: 21755
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.


[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: Thu Jan 26 18:41:43 CST 2023