I need to connect to the Production SAP system to run a real time job every month which extracts and load the data back to the system.
My Basis guy saying he cant give me SAP user with SAP_ALL role. Could anyone tell what are the other roles that need to be assigned to SAP user to fullfill my project.
In short: In development you need lots of permissions (still not SAP_ALL but you need to be ABAP developer) because your datastore is set to “generate_and_execute”. In prod, you don’t generate the ABAPs, you execute the uploaded ones, the datastore is set to “execute_preloaded”. Hence no permissions required at all.