oracle 10g中如何创建用户并授权

 

create user WXG identified by "qqq" 

default tablespace USERS 

temporary tablespace TEMP 

profile DEFAULT; 

grant connect to WXG;

 grant dba to WXG; 

grant resource to WXG; 

grant unlimited tablespace to WXG;