1.新建一个用户(sys登录)
create user kuang identified by kuang;
2.授予此用户connect权限
grant connect to testread ;
3.授予用户select on 权限(一张表)
grant select on ICMS_TYDB_TODOLIST to kuang;
3.授予用户select on 权限(所有表)
select 'grant select on '||owner||'.'||object_name||' to readest;'
from dba_objects
where owner ='CMSDEV'
and object_type='TABLE';
结果:
grant select on CMSDEV.ICMS_TYDB_CONFIG to kuang;
grant select on CMSDEV.ICMS_TYDB_DONELIST to kuang;
grant select on CMSDEV.ICMS_TYDB_DONE_HISTORY to kuang;
4.根据导出结果执行。