Create? user? UserName? Identified? By? UserPassword;??//创建用户

GRANT? SELECT? ANY? DICTIONARY? TO? UserName;? //授予所有字典的查询权限
?
GRANT? SELECT? ANY? SEQUENCE? TO? UserName;? //授予所有序列的查询权限
?
GRANT? SELECT? ANY? TABLE? TO? UserName; ?//授予所有表的查询权限

GRANT? SELECT? ANY??VIEW? TO? UserName; //授予所有视图的查询权限

?

?

?

--1. 创建用户
create user uname identified by upwd temporary tablespace temp default tablespace aaaa_DATA quota unlimited on aaaaa_DATA;

--2. 分配权限
grant connect,resource to uname;
alter user uname default role connect,resource;?

?