ACCEPT pv_newuser PROMPT 'Enter the new user ID: '

CREATE USER "&pv_newuser" IDENTIFIED EXTERNALLY
         DEFAULT TABLESPACE USERS 
         TEMPORARY TABLESPACE TEMP
         QUOTA 100M on users
         QUOTA 100M on temp;
         GRANT ITECSTUDENT TO "&pv_newuser";