oracle创建只读用户

LNSY_DBA为数据库实例
LNSY_DBA_READ为创建的只读用户

–创建用户
create user LNSY_DBA_READ identified by 123456;
–授权
grant connect to LNSY_DBA_READD;
grant create synonym to LNSY_DBA_READ;
grant create session to LNSY_DBA_READ;

查询表权限：复制下面的查询结果，执行
select ‘grant select on ‘||owner||’.’||object_name||’ to LNSY_DBA_READ;’ from dba_objects where owner in (‘LNSY_DBA’)and object_type=‘TABLE’;

创建同义词：复制下面的查询结果，执行
select ‘create or replace SYNONYM LNSY_DBA_READ.’ || object_name|| ’ FOR ’ || owner || ‘.’ || object_name|| ‘;’
from dba_objects
where owner in (‘LNSY_DBA’)
and object_type=‘TABLE’;

如果要赋予所有实例下表的查询权限
GRANT SELECT ANY TABLE TO LNSY_DBA_READ;