SQL> 
SQL> create user &&Enter_user_name identified by &&Enter_Password
  2  	    default   tablespace CLASS_DATA
  3  	    temporary tablespace temp
  4  	    quota 5 M on CLASS_DATA;
Enter value for enter_user_name: james
Enter value for enter_password: james
old   1: create user &&Enter_user_name identified by &&Enter_Password
new   1: create user james identified by james

User created.

SQL> 
SQL> grant connect	to &Enter_user_name;
old   1: grant connect      to &Enter_user_name
new   1: grant connect      to james

Grant succeeded.

SQL> grant create table to &Enter_user_name;
old   1: grant create table to &Enter_user_name
new   1: grant create table to james

Grant succeeded.

SQL> 
SQL> spool off