Document toolboxDocument toolbox

Rights and Authorizations - BW

Owned by Alexander Dürrstein
Last updated: May 17, 2024
3 min read

You can Install the Role /BLTG/MAPI_BW via Transport Request (download ).

Depending on the approach you have chosen, you will need a HANA or a BW user. The tables which have to be authorized can be copied from the list below. In case of an BW user the tables should be included into authorization object S_TABU_NAM with activity 3 (display). Besides that the authorization object S_RFC is needed with RFC_TYPE = FUGR and FUNC, activity 16 (execute) and the following characteristics in RFC_NAME:

  • /BLTG/*

  • DDIF_FIELDINFO_GET

  • RFCPING

  • RFC_GET_FUNCTION_INTERFACE

  • RFC_READ_TABLE

  • RFC_SYSTEM_INFO

If you use the HANA connection you can create a hdbrole in your HANA database with the following statements to have all the rights you need.
If you want to make it easier you can simply authorize the schema of your BW system with select rights.

role <your package name>::<your role name>{ --Object Level catalog sql object "<your BW schema name>"."TCESYST": SELECT; catalog sql object "<your BW schema name>"."RSAOOBJT": SELECT; catalog sql object "<your BW schema name>"."RSAOOBJXREF": SELECT; catalog sql object "<your BW schema name>"."RSBOHDESTT": SELECT; catalog sql object "<your BW schema name>"."RSDCUBEMULTI": SELECT; catalog sql object "<your BW schema name>"."RSDCUBET": SELECT; catalog sql object "<your BW schema name>"."RSDIOBJT": SELECT; catalog sql object "<your BW schema name>"."RSDODSOT": SELECT; catalog sql object "<your BW schema name>"."RSDST": SELECT; catalog sql object "<your BW schema name>"."RSFBPSEMANTICS": SELECT; catalog sql object "<your BW schema name>"."RSFBPSOURCE": SELECT; catalog sql object "<your BW schema name>"."RSFBPT": SELECT; catalog sql object "<your BW schema name>"."RSKSNEWT": SELECT; catalog sql object "<your BW schema name>"."RSOADSOT": SELECT; catalog sql object "<your BW schema name>"."RSOHCPRT": SELECT; catalog sql object "<your BW schema name>"."RSOOBJXREF": SELECT; catalog sql object "<your BW schema name>"."RSPLS_ALVL": SELECT; catalog sql object "<your BW schema name>"."RSPLS_ALVLT": SELECT; catalog sql object "<your BW schema name>"."RSQISETT": SELECT; catalog sql object "<your BW schema name>"."RSQTOBJ": SELECT; catalog sql object "<your BW schema name>"."RSTRAN": SELECT; catalog sql object "<your BW schema name>"."RSTRANT": SELECT; catalog sql object "<your BW schema name>"."TADIR": SELECT; catalog sql object "<your BW schema name>"."V_CMP_JOIN": SELECT; catalog sql object "<your BW schema name>"."V_ELTDIR_TXT": SELECT; catalog sql object "<your BW schema name>"."V_REP_JOIN": SELECT; catalog sql object "<your BW schema name>"."RSOOBJXREF_HANA": SELECT; catalog sql object "<your BW schema name>"."RSDVCHA": SELECT; catalog sql object "<your BW schema name>"."RSDODSO": SELECT; catalog sql object "<your BW schema name>"."RSQISET": SELECT; catalog sql object "<your BW schema name>"."RSDCUBE": SELECT; catalog sql object "<your BW schema name>"."RSAOOBJ": SELECT; --Field Level catalog sql object "<your BW schema name>"."DD03L": SELECT; catalog sql object "<your BW schema name>"."DD07T": SELECT; catalog sql object "<your BW schema name>"."RSBOHDEST": SELECT; catalog sql object "<your BW schema name>"."RSBOHFIELDS": SELECT; catalog sql object "<your BW schema name>"."RSBOHFIELDST": SELECT; catalog sql object "<your BW schema name>"."RSDATRNAVT": SELECT; catalog sql object "<your BW schema name>"."RSDBCHATR": SELECT; catalog sql object "<your BW schema name>"."RSDBCHATRXXL": SELECT; catalog sql object "<your BW schema name>"."RSDCHA": SELECT; catalog sql object "<your BW schema name>"."RSDCHABAS": SELECT; catalog sql object "<your BW schema name>"."RSDIOBJCMP": SELECT; catalog sql object "<your BW schema name>"."RSDKYF": SELECT; catalog sql object "<your BW schema name>"."RSDS": SELECT; catalog sql object "<your BW schema name>"."RSDSSEGFD": SELECT; catalog sql object "<your BW schema name>"."RSDSSEGFDT": SELECT; catalog sql object "<your BW schema name>"."RSDVTIM": SELECT; catalog sql object "<your BW schema name>"."RSDVUNI": SELECT; catalog sql object "<your BW schema name>"."RSFBP": SELECT; catalog sql object "<your BW schema name>"."RSFBPFIELD": SELECT; catalog sql object "<your BW schema name>"."RSFBPFIELDT": SELECT; catalog sql object "<your BW schema name>"."RSFBPNAVATR": SELECT; catalog sql object "<your BW schema name>"."RSFBPNAVATRT": SELECT; catalog sql object "<your BW schema name>"."RSFOBUEV001": SELECT; catalog sql object "<your BW schema name>"."RSKSFIELDNEW": SELECT; catalog sql object "<your BW schema name>"."RSKSFIELDNEWT": SELECT; catalog sql object "<your BW schema name>"."RSKSNEW": SELECT; catalog sql object "<your BW schema name>"."RSOADSO": SELECT; catalog sql object "<your BW schema name>"."RSOHCPR": SELECT; catalog sql object "<your BW schema name>"."RSPLS_ALVL_IOBJ": SELECT; catalog sql object "<your BW schema name>"."RSTRANFIELD": SELECT; catalog sql object "<your BW schema name>"."RSTRANRULE": SELECT; catalog sql object "<your BW schema name>"."RSTRANRULET": SELECT; catalog sql object "<your BW schema name>"."RSTRANSTEPADSO": SELECT; catalog sql object "<your BW schema name>"."RSTRANSTEPCNST": SELECT; catalog sql object "<your BW schema name>"."RSTRANSTEPMASTER": SELECT; catalog sql object "<your BW schema name>"."RSTRANSTEPROUT": SELECT; catalog sql object "<your BW schema name>"."RSZCALC": SELECT; catalog sql object "<your BW schema name>"."RSZCOMPDIR": SELECT; catalog sql object "<your BW schema name>"."RSZELTDIR": SELECT; catalog sql object "<your BW schema name>"."RSZELTPROP": SELECT; catalog sql object "<your BW schema name>"."RSZELTTXT": SELECT; catalog sql object "<your BW schema name>"."RSZELTXREF": SELECT; catalog sql object "<your BW schema name>"."RSZGLOBV": SELECT; catalog sql object "<your BW schema name>"."RSZRANGE": SELECT; catalog sql object "<your BW schema name>"."RSZSELECT": SELECT; catalog sql object "<your BW schema name>"."RSZELTATTR": SELECT; --Transformation Code Scan catalog sql object "<your BW schema name>"."RSAABAP": SELECT; catalog sql object "<your BW schema name>"."RSTRANSTEPSCRIPT": SELECT; catalog sql object "<your BW schema name>"."SEOCLASSDF": SELECT; catalog sql object "<your BW schema name>"."TMDIR": SELECT; catalog sql object "<your BW schema name>"."TRDIR": SELECT; }

 

© 2024 bluetelligence GmbH. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of bluetelligence GmbH. The information contained herein may be changed without prior notice. bluetelligence and Performer Suite and their respective logos are trademarks or registered trademarks of bluetelligence GmbH. SAP, ABAP, BAPI, SAP NetWeaver, SAP BI, SAP BW, SAC, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany or an SAP affiliate company. All other product and service names mentioned are the trademarks of their respective companies.
Impressum – Legal Notice: https://bluetelligence.de/en/imprint
Privacy policy: https://performersuite.de/en/privacy-policy
Atlassian privacy policy: https://www.atlassian.com/legal/privacy-policy