Revoke unnecessary privileges for applsyspub
Hi experts,
Customer discovered that APPLSYSPUB has privileges on dbms_pipe.
When reviewing APPLSYSPUB in 11i, and verifying its privileges they noticed that it has execute on dbms_pipe.
Customer wants to revoke the privilege, but don't want to cause an
issue. So they are asking advise if they can safely revoke the
privileges.
I've provided the following update:
To answer your question, I did a research and I found that APPLSYSPUB
user is Initial, pre-authentication user with minimal privileges to
assist with APPS (FND) user authentication.
The following note will provide you clarification about how to secure your instance and what you can do with APPLSYSPUB user: