1、创建用户
create user userName identified by password;
2、生成授权语句
select 'grant select on user1.'||table_name||' to user2;'from all_tableswhere owner = 'user1';
然后执行授权语句
3、赋予session权限
grant create session,resource to user2
本文共 266 字，大约阅读时间需要 1 分钟。
create user userName identified by password;
select 'grant select on user1.'||table_name||' to user2;'from all_tableswhere owner = 'user1';
然后执行授权语句
grant create session,resource to user2
转载于:https://my.oschina.net/u/182501/blog/1789499