Database Administration (MOSC)

MOSC Banner

Oracle Database Hardening - Revoking of execution on packages from public caused database to crash

edited Sep 24, 2020 11:06AM in Database Administration (MOSC) 1 commentAnswered

Due to audit requirements, i have performed hardening on the database. I have revoked the execution of the packages from public and it caused the database to crash.

I am having oracle19c, applied with the latest Jul-2020 CPU running on windows server.

Anyone faced the same issue and has any solution for that.

Thank you.

REVOKE EXECUTE ON DBMS_LDAP FROM PUBLIC;
REVOKE EXECUTE ON UTL_INADDR FROM PUBLIC;
REVOKE EXECUTE ON UTL_TCP FROM PUBLIC;
REVOKE EXECUTE ON UTL_MAIL FROM PUBLIC;
REVOKE EXECUTE ON UTL_SMTP FROM PUBLIC;
REVOKE EXECUTE ON UTL_DBWS FROM PUBLIC;
REVOKE EXECUTE ON UTL_ORAMTS FROM PUBLIC;

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