Oracle Database Hardening - Revoking of execution on packages from public caused database to crash
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; |