Oracle 10g Free Training - Creating Roles and Granting Privileges: This tutorial provides the ways and steps of creating and managing database roles and privileges using three ways via SQL Plus, iSQL Plus and Enterprise Manager .

Create Roles

There could be two ways of creating users account in oracle10g. 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 Roles through Sql Plus

1. Login to 10g SQL*PLUS using your administrator user id and password.
2. Issue the CREATE ROLE command in the sql*plus window to create a role as shown in figure 1 below .

Figure 1. Create Role command through SQL*PLUS

Creating Roles through iSQL*PLUS

1. 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 Roles through EM

   
   
   1. Open internet explorer and enter the URL for Enterprise manager. (http://
      
      

      Figure 3. Oracle Enterprise Manager window

      
      

      3. The Administration page would appear as shown in figure 4 below. Click on the Roles tab under the Security section.

      
      

      

      
      

      Figure 4. Administration Page

      
      

      Next Page: Oracle 10g Free Training - Creating Roles and Granting Privileges - Page 2