yesterday we hit a bug in 11.2.0.3:
if you grant various dbms_* packages to another user “with grant” option and try to pass through this grant with that user you may hit bug 13036331
simple test-case to confirm that you are affected:
create user blubb identified by "blubb"; create user blabb identified by "blabb"; grant connect,resource to blubb; grant execute on dbms_lob to blubb with grant option; connect blubb/blubb grant execute on dbms_lob to blabb; * ERROR at line 1: ORA-01031: insufficient privileges
it seems that only 11.2.0.3 is affected. we already had a psu applied ( 11.2.0.3.1 ), so this does not help…