on 01-28-2015 8:52 AM
Hi all,
I have got a problem with the ERP permissions for the DS connection.
Actual I get an RFC-CallReceive error, when I try to import tables:
It looks like, that the erp user has not all permissions he need.
I have read the DS supplement guide for SAP. This guide says, that I need the following permissions.
S_BTCH_JOB
S_RFC
S_TABU_DIS
S_TCODE
After that, the error was still there and the user needs the S_DSAUTH permission. Next step the user needs S_SDS, so I could not see an end and in my opinion it is not a great way to trace the permissions every time after grant a new one, until it works.
My question is, which permissions the user needs to import tables and load data from the ERP? (In best case you could tell me, where I could find this information).
Regards
Severin
P.S.: SAP_ALL is no option
Severin,
The additional auth object is S_DEVELOP which you will get only in the development client and not in your QA/Prod client (I hope ). You need to create a single SAP ECC datastore with multiple configurations, one pointing to DEV, the second to QA and so on. All your table imports and ABAP DFs should be done with the datastore pointing to the DEV client. Once the table imports/development is done, you can point your datastore to QA/PROD and run your jobs against it.
So basically, the following auth objects should suffice:
For DEV:
S_BTCH_JOB
S_RFC
S_TABU_DIS
S_TCODE
S_DEVELOP
For QA/PROD,etc:
S_BTCH_JOB
S_RFC
S_TABU_DIS
S_TCODE
-Chaitanya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am not sure I understand completely but you should NOT try to import tables with your datastore pointing to PROD. Below is how my SAP datastore looks with the default config pointing to DEV. DEV should have the 'S_DEVELOP' auth object.
1) Import your tables with your data store pointing to DEV.
2) Change config in datastore to point to your PROD or use system configurations if you have them and read data from PROD.
Good to know it's working. While I figured it out the hard by working with a security team that set up a trace. I later found the document below specific to SAP upgrades. The authorizations are mentioned on Page 13 and 14.
http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_upgrade_en.pdf
Cheers,
Chaitanya
All the necesary information is in the SAP Data Services Supplement for SAP guide, indeed. More particular in section 2.4 SAP User authorizations.
But note that there's a difference between the production profile (the one you have selected) and the development and test profile (the one you need): you're missing S_DEVELOP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.