create user wu identified by 123456;

grant create session to 用户名;

grant create table to 用户名;

grant create tablespace to 用户名;

grant create view to 用户名;

grant connect,resource,dba to wu;

GRANT connect,resource to wu;

GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO wu;