EBS Security Readiness Analyzer "Check Unnecessary Privileges Granted to APPLSYSPUB account" Returns Less Records Then Output from EBSSecConfigChecks.sql "Check: For excessive privs in APPLSYSPUB" (Doc ID 2856493.1)

Last updated on MARCH 17, 2022

Applies to:

Symptoms

When running EBS Security Readiness Analyzer "Check Unnecessary Privileges Granted to APPLSYSPUB account" shows
less records then the output of EBSSecConfigChecks.sql "Check: For excessive privs in APPLSYSPUB".

Steps
1. Run EBS Security Readiness Analyzer that can be obtained from EBS Security Readiness Analyzer (<Document:2603839.1>)

Below output is observed on EBS Security Readiness Analyzer Report　> Database Privileges Validation > Check Unnecessary Privileges Granted to APPLSYSPUB account

APPS_NE EXECUTE CCT_QDE_RESPONSE
APPS_NE EXECUTE ECXMSG
APPS_NE EXECUTE ECX_OUTENGOBJ
APPS_NE EXECUTE ECX_INENGOBJ
APPS_NE EXECUTE MRP_IPC_TASK_MSG_PAYLOAD
APPS_NE EXECUTE MRP_IPC_NUMBER_MSG_PAYLOAD
APPS_NE EXECUTE MRP_IPC_INFO_MSG_PAYLOAD
APPS_NE EXECUTE AMV_AQ_MSG_OBJECT_TYPE
APPS_NE EXECUTE FND_CP_GSM_OPP_AQ_PAYLOAD
APPS_NE EXECUTE FND_CP_GSM_IPQ_AQ_PAYLOAD
APPS_NE EXECUTE FND_CP_TM_AQ_PAYLOAD
APPS_NE EXECUTE WF_PAYLOAD_T
APPS_NE EXECUTE WF_MESSAGE_PAYLOAD_T
APPS_NE EXECUTE AR_REV_REC_TYP
APPS_NE EXECUTE CCT_IBMEDIA_TYPE
APPS_NE EXECUTE IEO_ICSM_MSG_TYPE
APPS_NE EXECUTE IH_BULK_TYPE
APPS_NE EXECUTE JTF_EXCEP_MSG_OBJ
APPS_NE EXECUTE JTF_STAGING_MSG_OBJ
APPS_NE EXECUTE JTF_MSG_OBJ


2. Run EBSSecConfigChecks.sql that can be obtained from Security Configuration and Auditing Scripts for Oracle E-Business Suite (<Document:2069190.1>)

Below output is observed.

***************************************************
* Check: For excessive privs in APPLSYSPUB
***************************************************

GRANTOR PRIVILEGE TABLE_NAME
------------------------ -------------- --------------------------------
APPS_NE EXECUTE CCT_QDE_RESPONSE
APPS_NE EXECUTE ECXMSG
APPS_NE EXECUTE ECX_OUTENGOBJ
APPS_NE EXECUTE ECX_INENGOBJ
APPS_NE EXECUTE MRP_IPC_TASK_MSG_PAYLOAD
APPS_NE EXECUTE MRP_IPC_NUMBER_MSG_PAYLOAD
APPS_NE EXECUTE MRP_IPC_INFO_MSG_PAYLOAD
APPS_NE EXECUTE AMV_AQ_MSG_OBJECT_TYPE
APPS_NE EXECUTE FND_CP_GSM_OPP_AQ_PAYLOAD
APPS_NE EXECUTE FND_CP_GSM_IPQ_AQ_PAYLOAD
APPS_NE EXECUTE FND_CP_TM_AQ_PAYLOAD
APPS_NE EXECUTE WF_PAYLOAD_T
APPS_NE EXECUTE WF_MESSAGE_PAYLOAD_T
APPS_NE EXECUTE AR_REV_REC_TYP
APPS_NE EXECUTE CCT_IBMEDIA_TYPE
APPS_NE EXECUTE IEO_ICSM_MSG_TYPE
APPS_NE EXECUTE IH_BULK_TYPE
APPS_NE EXECUTE JTF_EXCEP_MSG_OBJ
APPS_NE EXECUTE JTF_STAGING_MSG_OBJ
APPS_NE EXECUTE JTF_MSG_OBJ
APPS_NE EXECUTE ASO_HEADER_TYPE
APPS_NE EXECUTE ASO_HEADER_VAR_TYPE
APPS_NE EXECUTE ASO_HEADER_ADJ_TYPE
APPS_NE EXECUTE ASO_HEADER_ADJ_VAR_TYPE
APPS_NE EXECUTE ASO_HEADER_PRICE_ATT_TYPE
APPS_NE EXECUTE ASO_HEADER_PRICE_ATT_VAR_TYPE
APPS_NE EXECUTE ASO_HEADER_ADJ_ATT_TYPE
APPS_NE EXECUTE ASO_HEADER_ADJ_ATT_VAR_TYPE
APPS_NE EXECUTE ASO_HEADER_ADJ_ASSOC_TYPE
APPS_NE EXECUTE ASO_HEADER_ADJ_ASSOC_VAR_TYPE
APPS_NE EXECUTE ASO_HEADER_SCREDIT_TYPE
APPS_NE EXECUTE ASO_HEADER_SCREDIT_VAR_TYPE
APPS_NE EXECUTE ASO_LINE_TYPE
APPS_NE EXECUTE OKC_AQ_MSG_TYP
APPS_NE EXECUTE ASO_LINE_VAR_TYPE
APPS_NE EXECUTE ASO_LINE_ADJ_TYPE
APPS_NE EXECUTE ASO_LINE_ADJ_VAR_TYPE
APPS_NE EXECUTE ASO_LINE_PRICE_ATT_TYPE
APPS_NE EXECUTE ASO_LINE_PRICE_ATT_VAR_TYPE
APPS_NE EXECUTE ASO_LINE_ADJ_ATT_TYPE
APPS_NE EXECUTE ASO_LINE_ADJ_ATT_VAR_TYPE
APPS_NE EXECUTE ASO_LINE_ADJ_ASSOC_TYPE
APPS_NE EXECUTE ASO_LINE_ADJ_ASSOC_VAR_TYPE
APPS_NE EXECUTE ASO_LINE_SCREDIT_TYPE
APPS_NE EXECUTE ASO_LINE_SCREDIT_VAR_TYPE
APPS_NE EXECUTE ASO_LOT_SERIAL_TYPE
APPS_NE EXECUTE ASO_LOT_SERIAL_VAR_TYPE
APPS_NE EXECUTE ASO_REQUEST_TYPE
APPS_NE EXECUTE ASO_REQUEST_VAR_TYPE
APPS_NE EXECUTE ASO_ORDER_FEEDBACK_TYPE
APPS_NE EXECUTE XDP_WF_CHANNELQ_TYPE
APPS_NE EXECUTE XDP_WF_FAQ_TYPE
APPS_NE EXECUTE XDP_WF_ORDERQ_TYPE
APPS_NE EXECUTE XDP_ORDER_OBJ
APPS_NE EXECUTE XDP_WF_RESUMEQ_TYPE
APPS_NE EXECUTE XNP_MESSAGE_TYPE

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.