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://

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://

Figure 3. Oracle Enterprise Manager window

Next Page: Oracle 10g Free Training- Administering and Managing Users - Page 2