Database Administration (MOSC)

MOSC Banner

public execute DBMS_REPUTIL removed in databases created in 11.2.0.4

edited Jan 31, 2014 2:53AM in Database Administration (MOSC) 6 commentsAnswered ✓

 I came across a change in behavior in 11.2.0.4 which isn't documented.

I'd created a database for our developers as 11.2.0.4 when they raised an issue with getting an error "PLS-00201: identifier "DBMS_REPUTIL' must be declared"

Digging a bit deeper is seems that the the GRANT EXECUTE ON dbms_reputil TO PUBLIC lines  are removed from the dbmsgen.sql script in 11.2.0.4
There is a  comment in the script about it that references  bug 16681267.

The grant remains in place on upgraded databases - so DB's created in 11.2.0.3 and earlier then upgraded to 11.2.0.4 are unaffected, just newly created DB's
and DBMS_REPUTIL2 is also affected.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center