1.登录到当前用户
2.select 'grant select on XYD_IDX_DEV.' || t.table_name || ' to DMC_ZGRS_RPTWEB;' from user_tables t where table_name like '%GX%';
3.执行下面生成的语句
1.登录到当前用户
2.select 'grant select on XYD_IDX_DEV.' || t.table_name || ' to DMC_ZGRS_RPTWEB;' from user_tables t where table_name like '%GX%';
3.执行下面生成的语句
转载于:https://my.oschina.net/u/2929747/blog/1154622