scott@ORA92> CREATE USER TEST IDENTIFIED BY TEST;

User created.

scott@ORA92> GRANT CREATE SESSION TO TEST;

Grant succeeded.

scott@ORA92> GRANT UNLIMITED TABLESPACE TO TEST;

Grant succeeded.

scott@ORA92> @ CONNECT TEST/TEST
test@ORA92> CREATE GLOBAL TEMPORARY TABLE TEST (TEST NUMBER);
CREATE GLOBAL TEMPORARY TABLE TEST (TEST NUMBER)
*
ERROR at line 1:
ORA-01031: insufficient privileges

test@ORA92> @ CONNECT SCOTT
Enter password: *****
scott@ORA92> GRANT RESOURCE TO TEST;

Grant succeeded.

scott@ORA92> @ CONNECT TEST/TEST
test@ORA92> CREATE GLOBAL TEMPORARY TABLE TEST (TEST NUMBER);

Table created.

test@ORA92>