oracle 创建只读用户

drop user shop_read;
drop role shop_read_role;
create user shop_read identified by "123433";
CREATE ROLE shop_read_role ;

grant SELECT ANY DICTIONARY to shop_read_role; 
grant SELECT ANY TABLE to shop_read_role; 
grant SELECT ANY TRANSACTION to shop_read_role; 
grant SELECT ANY SEQUENCE to shop_read_role; 
grant  connect to shop_read_role; 

grant shop_read_roleto shop_read; 

select * from shop.order; 

说明：表查询方式，一定要加表所属用户shop