begin
for i in (select 'grant select on ' || table_name || ' to imes' as stm
from user_tables
where table_name not like '%$%'
) loop
execute immediate i.stm;
end loop;
end;
这样 imes 可以访问 所有wipdba下的表了
标签：imes,end,name,循环,Oracle,table,权限,select From： https://www.cnblogs.com/hlm750908/p/16720849.html