Execute privilege on dbms_reputil package has been revoked from PUBLIC user by default on 11.2.0.4 and higher versions (Doc ID 1618639.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Goal

PUBLIC user has execute privilege on dbms_reputil package till database version 11.2.0.3 however its revoked starting from 11.2.0.4 version as show below :

On 11.2.0.3 version :

SQL> select GRANTEE ,TABLE_NAME ,PRIVILEGE from DBA_TAB_PRIVS where TABLE_NAME='DBMS_REPUTIL';

GRANTEE                        TABLE_NAME                     PRIVILEGE
------------------------------ ------------------------------ ----------------------------------------
PUBLIC                         DBMS_REPUTIL                   EXECUTE

on 11.2.0.4 version :

SQL> select GRANTEE ,TABLE_NAME ,PRIVILEGE from DBA_TAB_PRIVS where TABLE_NAME='DBMS_REPUTIL';

no rows selected

 This note explains this change in behavior and available workaround.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms