Oracle 10G XE User Management 101 - What if you are a first time user?

(Page 4 of 4 )

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.

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Oracle 10G XE User Management 101

· This is really basic stuff. For a free database you cannot possibly hire a dba and...   >>> Post your comment now!