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.
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>"."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>"."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;
}