Skip to Main Content

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 on DBMS_REPUTIL fails

kamilpMar 10 2015 — edited Mar 10 2015

Hi,

I just installed Oracle Database 11g Release 11.2.0.4.0 - 64bit Production, and I need grant execute on DBMS_REPUTIL to user for trigger compatibility. I get error:

SQL> GRANT EXECUTE ON DBMS_REPUTIL TO PUBLIC;

GRANT EXECUTE ON DBMS_REPUTIL TO PUBLIC

                 *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> grant execute on DBMS_REPUTIL to webusr

                 *

ERROR at line 1:

ORA-00942: table or view does not exist

What is the problem with grant command ? Anyone can suggest how to grant execute on that package ?

Here is my oracle version:

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

Thanks !

This post has been answered by unknown-951199 on Mar 10 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2015
Added on Mar 10 2015
4 comments
1,371 views