How To Unlock the Sample User Account

Q

How To Unlock the Sample User Account? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition

✍: FYIcenter.com

A

Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it:

  • Log into the server home page as SYSTEM.
  • Click the Administration icon, and then click Database Users.
  • Click the HR schema icon to display the user information for HR.
  • Enter a new password (hr) for HR, and change the status to Unlocked.
  • Click Alter User to save the changes.

Now user account HR is ready to use.

2007-04-24, 4552👍, 0💬