Oracle循环设置表权限

 

 

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下的表了