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表空间初始化、创建用户、赋权和数据导入
posted @ 2017-11-08 17:10  wumengjuan  阅读(440)  评论(0编辑  收藏  举报