//创建临时表空间   
  
create temporary tablespace user_temp   
tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'  
size 50m   
autoextend on   
next 50m maxsize 20480m   
extent management local;   
  
//创建数据表空间   
create tablespace user_data   
logging   
datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf'  
size 50m   
autoextend on   
next 50m maxsize 20480m   
extent management local;   
  
//创建用户并指定表空间   
create user username identified by password   
default tablespace user_data   
temporary tablespace user_temp;   
  
//给用户授予权限   
  
grant connect,resource to username;