创建公共用户public_user

create user public_user identified by public_user;
grant connect ,create view to public_user;

创建角色role_select_all

create role role_select_all;

授权需要用的公共用户user1 、user2、user3用户下所有表的 select 权限给角色 role_select_all

创建授权语句

select 'GRANT SELECT ON ' || 'user1.' ||table_name || ' to role_select_all;'  from user_tables

使用授权语句给角色role_select_all授权

授权角色role_select_all 给公共用户public_user

grant role_select_all to public_user;

登录公共用户mdsd20 查询验证