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 !