I have created a new Oracle9i database using Oracle Database Configuration Assistant. I find that the user HR account has expired. How do I make this account active again?
This account needs its password changed. Sign on as SYSTEM and change the password. If the account is locked, you can unlock it with the following:
ALTER USER hr ACCOUNT UNLOCK;
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.