Oracle 10g Free Training- Administering and Managing Users

This tutorial explains the ways and steps of creating and managing database accounts, Creating Users through Sql Plus, Creating User through iSQL*PLUS, Creating Users through EM, Manager Users, Managing Users through sqlplus and Managing Users through EM.

Create Users

There are few ways of creating users account in oracle10g. In this tutorial we will discuss about 2 ways of creating them. You can directly create the users account through sqlplus after entering the commands or you can use enterprise manager (through internet explorer) to create users.

Creating Users through Sql Plus

Login to 10g SQL*PLUS using your administrator user id and password.

Issue the CREATE USER command as shown in the sql*plus window (figure 1) below to create a user.

Figure 1. Create User command through SQL*PLUS

Creating User through iSQL*PLUS

To connect to iSQL*PLUS, open the Internet Explorer and enter the following URL.
http://:5560/isqlplus

Use the administrator user id and password to login to iSQL*PLUS.

Enter the CREATE USER query in workspace box as shown in figure 2 below.

Click on EXECUTE button at the bottom to execute the SQL.

Figure 2. iSQL*PLUS Window

Method for creating users is exactly same in iSqlplus and Sqlplus. iSqlplus can be accessed through internet explorer.

Creating Users through EM

Open internet explorer and enter the URL for Enterprise manager. (http://:5500/em)

Click on the Administration tab shown in the figure 3 below.

Figure 3. Oracle Enterprise Manager window

The Administration page would look like as shown in figure 4 below. Click on the Users tab under the Security section.

Figure 4. Administration Page

The Users page would open up as shown in figure 5 below. Click on the CREATE button to create a user.

Figure 5. Create User tab

The Create User window would look like as shown in figure 6 below.

Figure 6. Create User Window

You can click on Show Sql Button to see the sql query which will be executed by em to create the user.

Figure 7. Show Sql Window

Click on Return Button to return to figure6. You can click on OK Button in figure6 to create the user and following window will appear in front of you.

Figure 8. User Created Window

This shows that user ‘SHARAD_VERMA’ has been created in the database.

Manager Users

Similar to creating users, user accounts can be managed either through EM or directly through sqlplus.

Managing Users through sqlplus

You can use following command to change the password of the user

Figure 9. Change Password Sqlplus Window

Managing Users through EM

Following window which is same as figure5 can be used to modify the user through EM.

Figure 10. Manager User EM Window

Following screen can be used to change password, default tablespace attached to the user.

Figure 11. Manage User General Window

Frequently Asked Questions

1. Can I create users through internet explorer in oracle 10g?
2. What is the significance of proxy user?
3. What is the significance of Consumer Group?
4. Can I grant tablespace quota to a user using EM?
5. What is the significance of attaching a profile while creating a user?