|
Page 1 of 3
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
|
