create user vackar_temp identified by "123456789";
grant create type  to vackar_temp ;

create type temp_col as table of number;

ORA-01031: insufficient privileges

grant resource to vackar_temp ;

select
  lpad(' ', 2*level) || granted_role "User, his roles and privileges"
from
  (
  /* THE USERS */
    select 
      null     grantee, 
      username granted_role
    from 
      dba_users
    where
      username like upper('%vackar_temp%')
  /* THE ROLES TO ROLES RELATIONS */ 
  union
    select 
      grantee,
      granted_role
    from
      dba_role_privs
  /* THE ROLES TO PRIVILEGE RELATIONS */ 
  union
    select
      grantee,
      privilege
    from
      dba_sys_privs
  )
start with grantee is null
connect by grantee = prior granted_role;

User, his roles and privileges 
------------------------------ 
  VACKAR_TEMP                  
    CREATE TYPE                
    RESOURCE                   
      CREATE CLUSTER           
      CREATE INDEXTYPE         
      CREATE OPERATOR          
      CREATE PROCEDURE         
      CREATE SEQUENCE          
      CREATE TABLE             
      CREATE TRIGGER           
      CREATE TYPE              
    UNLIMITED TABLESPACE     

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

SQL> create user pato identified by pato;

User created.

SQL> grant create session,
  2        create type
  3  to pato;

Grant succeeded.

SQL> connect pato/pato@ora10
Connected.

SQL> create type temp_col as table of number
  2  /

Type created.

SQL>