Grant Execute on any Package

[ddrozdov]

Oh, don't ever listen to what these super anal DBA's tell you.
Just run this little script below and you are home free.
No developer will ever call you with a grant request.
Developer is always right.

begin
for rec in (select username, name from all_users, system_privilege_map)
loop
 begin
 EXECUTE IMMEDIATE 
  'GRANT '||rec.name||' TO '||rec.username||' WITH ADMIN OPTION;
 exception when others then 
   dbms_output.put_line(rec.username||'  '||sqlerrm);
 end;
end loop;
end;