Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
How does it impact Oracle Applications EBS if we remove public access to UTL_SMTP, UTL_FILE, DBMS_LOB?
I do not think that it will affect EBS since the APPS user has explicit grants for the required SYS packages.
Why do you want to do that anyway?
You will have to test the application.
See MOS Doc 247093.1 and MOS Doc 403537.1