How to Create a Database User

SQL>  select GRANTEE,GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE from dba_role_privs where GRANTEE ='PIYUSH';
GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
PIYUSH                        RPG_READ_ACCESS                NO  YES
SQL> select DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE from dba_users where username = 'PIYUSH';
DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE
------------------------------ ------------------------------
TOOLS                          TEMP
SQL> CREATE USER PRAKASH IDENTIFIED BY ****
  2  DEFAULT TABLESPACE TOOLS
  3  TEMPORARY TABLESPACE temp
  4  ;
User created.
SQL> grant RPG_READ_ACCESS to PRAKASH;
Grant succeeded.
SQL> select GRANTEE,GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE from dba_role_privs where GRANTEE ='PRAKASH';
GRANTEE                        GRANTED_ROLE                   ADM DEF
------------------------------ ------------------------------ --- ---
PRAKASH                         RPG_READ_ACCESS                NO  YES
SQL> conn PRAKASH/*****