HomeOracle Page 4 - Oracle 10G XE User Management 101
What if you are a first time user? - Oracle
If you're a DBA, one of your basic tasks involves managing users: dropping, adding, and changing permissions. Even if you aren't a DBA, if you use a database, you may find it helpful to know the tasks that a DBA performs. This article explains the basics for how to perform these tasks in Oracle 10G XE.
In the very first tutorial the method for unlocking the HR user account was described. However this article is a more appropriate place. Since to start with there is only one login, that of the system, login with system as the user and the password created while installing Oracle 10G XE. After gaining entry to the database click on Administration and click on the Manage Users menu item which opens up the window shown next. You can see the HR user whose password has expired and note that the account is locked.
Click on the HR icon to open the user's details as shown in the next window.
Enter the password, hr. Confirm it by entering it again, use the drop-down to change HR's Account Status from Locked to Unlocked and click on the Alter User button. This brings up the next screen shown. Now the user hr can enter with the password hr and gain access to the database objects.
Summary
This tutorial is a 101 level administration "how-to" for managing users in Oracle 10G XE. It's a very easy to use interface for administering users. It is however very important to note down your password while installing. In addition to the roles that are discussed in the article, the machine also has entries for the Ora DBA group to which the users can belong -- as it happens, on Hodentek the user "jay" belongs to the ORA DBA group.
