Depending on the approach you have chosen, you will need a HANA or a BW an ERP user. The tables which has 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 ERP system with select rights.
| Code Block |
|---|
|
role <your package name>::<your role name>{
--Standard Edition
catalog sql object "<your BW schema name>SAPHANADB"."TCESYSTDD26S": SELECT;
catalog sql object "<your BW schema name>SAPHANADB"."RSAOOBJTDD02L": 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":SAPHANADB"."DDLDEPENDENCY": SELECT;
--Premium Edition
catalog sql object "<your BW schema name>SAPHANADB"."DD07TDD27S": 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;SAPHANADB"."DD03T": SELECT;
--Extended Edition
} |
