OraFAQ Forum: Security » login issue

Home » RDBMS Server » Security » login issue (oracle 9i / Win XP)

Thu, 19 November 2009 01:23

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.

Thu, 19 November 2009 02:02

Littlefoot
Messages: 21647
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]

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

Goto Forum:

]

Current Time: Sat Jan 16 05:54:12 CST 2021