oracle创建用户授权权限

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;

Oracle表空间初始化、创建用户、赋权和数据导入
原文地址:https://www.cnblogs.com/523823-wu/p/7805065.html