Do we required execute previlege on tables -UTL_TCP, UTL_SMTP, UTL_INADDR, UTL_HTTP, UTL_FILE (4252861)

Below are the privileges which needs to be revoked in QSRTPRG from PUBLIC. Please check with your team if these privileges are required to perform any application work. If not then you can raise CMP to GIDA team to revoke these privileges.

GRANTEE TABLE_NAME PRIVILEGE -------------------- ------------------------------ ----------------

PUBLIC UTL_TCP EXECUTE

PUBLIC UTL_SMTP EXECUTE

PUBLIC UTL_INADDR EXECUTE

PUBLIC UTL_HTTP EXECUTE

PUBLIC UTL_FILE EXECUTE

Eg:-

Revoke execute on SYS.UTL_TCP from PUBLIC;

Revoke execute on SYS.UTL_SMTP from PUBLIC;

Revoke execute on SYS.UTL_INADDR from PUBLIC;

Revoke execute on SYS.UTL_HTTP from PUBLIC;

Revoke execute on SYS.UTL_FILE from PUBLIC;