赋权操作另一用户的表

转载处：http://blog.csdn.net/xlb744868186/article/details/50818011

select * from (select 'Grant all on '|| table_name ||' to RMS;' grant_sql from all_tables where owner = upper('SDE')) where grant_sql like '%GIS_RESLOCATION_T%';