Unlock the Sample User Account in Oracle

Q

How To Unlock the Sample User Account in Oracle?

✍: 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.

 

Change System Global Area (SGA) in Oracle

Shutdown 10g XE Server from Commmand Line in Oracle

Introduction to Oracle Database 10g Express Edition

⇑⇑ Oracle Database Tutorials

2020-09-30, 1566🔥, 0💬