ORACLE用户的创建与授只读权
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;?
?
