Ask the Expert

Activating HR account

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?

    Requires Free Membership to View

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;

This was first published in April 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.