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;