Revoke default package (DBMS_LDAP, UTL_INADDR, OWA_UTIL, DBMS_CREDENTIAL .. ) from public
Dear Sir/Madam
As external audit recommend to revoke below from public
Doe it will impact database or system?
--REVOKE EXECUTE ON .. FROM PUBLIC;
--Network packages
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_SMTP FROM PUBLIC;
REVOKE EXECUTE ON UTL_HTTP FROM PUBLIC;
REVOKE EXECUTE ON HTTPURITYPE FROM PUBLIC;
-- File System packages
REVOKE EXECUTE ON DBMS_ADVISOR FROM PUBLIC;
REVOKE EXECUTE ON UTL_FILE FROM PUBLIC;
-- Encryption Packages
REVOKE EXECUTE ON DBMS_OBFUSCATION_TOOLKIT FROM PUBLIC;
REVOKE EXECUTE ON DBMS_RANDOM FROM PUBLIC;