如何创建只读权限oracle账户

1. 创建角色 
   CREATE ROLE SELECT_ROLE 
   2.给角色分配权限 
   grant SELECT ANY DICTIONARY to SELECT_ROLE; 
   grant SELECT ANY TABLE to SELECT_ROLE; 
   grant SELECT ANY TRANSACTION to SELECT_ROLE; 
   grant SELECT ANY SEQUENCE to SELECT_ROLE; 
   3.把角色赋予指定账户 
   grant SELECT_ROLE to user; 
   4.删除角色 
   drop role SELECT_ROLE;

   5、创建用户

   create user db_hxzg identified by 123 

   6、赋给账号连接权限

   grant connect, resource to aaaa;
   

   grant create session to aaaa;
   

7.检查角色的权限 
select * from dba_sys_privs where grantee=’SELECT_ROLE’

测试权限的时候需要加上用户的对象例如 
select count(*) from hr.ex_user;