- 创建用户
create user c##u用户名 identified by 密码;
- 授权普通连接权限
grant connect to c##用户名;
- 生成只读授权语句
select 'grant select on '||owner||'.'||object_name||' to 刚刚创建的用户名;'
from dba_objects
where
owner in ('本实例拥有权限的用户名必须大写')
and
object_type='TABLE';
create user c##u用户名 identified by 密码;
grant connect to c##用户名;
select 'grant select on '||owner||'.'||object_name||' to 刚刚创建的用户名;'
from dba_objects
where
owner in ('本实例拥有权限的用户名必须大写')
and
object_type='TABLE';