Are the Delete Privileges from the Config Schema to the Atomic Schema Required?
(Doc ID 2294264.1)
Last updated on FEBRUARY 26, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Goal
The following delete privileges appear to be automatically granted from the config to atomic schema. Are these required as per bank policy there are not suppose to exist delete grants from one schema to other schema?
GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRA HIE COM TYPE
---------------------------- ---------------------------- ----------------------------------- ---------------------------- -------------------- --- --- --- ------------------------
ATOMIC CONFIG AAI_MAP_MAPPER CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG BATCH_RUN CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG MESSAGES_EN_US CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG PR2_RULE_MAP_EXCLUDE_PR CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG PR2_RULE_MAP_EXCLUDE_PR_TMP CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG PR2_RULE_MAP_PR CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG PR2_RULE_MAP_PR_TMP CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG DOCUMENT_MASTER CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_SETUP_QTN_CONF_TYP CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_SETUP_QTN_CONF_TYP_MLS CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_FCT_QTNR_CONF CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_PURPOSE CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_PURPOSE_MLS CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTNR_TYPE CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTNR_TYPE_MLS CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_EMPLOYEE CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTN_CATEGORY CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTN_CATEGORY_MLS CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTN_SEL_TYPE CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTN_SEL_TYPE_MLS CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTN_TYPE CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTN_TYPE_MLS CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTNR_APP_TYPES CONFIG DELETE NO NO NO TABLE
ATOMIC CONFIG AAI_ABC_DIM_QTNR_APP_TYPES_MLS CONFIG DELETE NO NO NO TABLE
Is it mandatory to have these privileges. If yes, what is the reason? If no, can these grants be revoked?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |