Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"GRANT EXECUTE ANY PROCEDURE TO " does not work in some cases

MynzDec 7 2011 — edited Dec 7 2011

Hello,

I some of my PL/SQL-packages I'm using DBMS-packages.

Because I don't want to grant access for every single package, I granted EXECUTE ANY PROCEDURE to the user/schema of my packages.

This did work in several installation.

But for what reason ever, in one installation DBMS_RANDOM cannot be used (DBMS_RANDOM must be declared). If I explicitly grant execute on this package, it works. When I revoke it and renew the ANY PROCEDURE, it doesn't again.

What's wrong.

Version 11.2.0.2 on Win2008R2

Regards,

Mynz

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2012

Added on Dec 7 2011

#general-database-discussions

3 comments

552 views