Depending on the approach you have chosen, you will need a HANA or a BW user. The tables which has 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>{
--Standard Edition
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;
--Premium Edition
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>"."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;
--Extended Edition
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;
}