...
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 RFC connection you need the tables of the list below too. 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:
...
| Code Block | ||
|---|---|---|
| ||
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;
catalog sql object "<your BW schema name>"."RSBASIDOC": SELECT;
catalog sql object "<your BW schema name>"."RSDSEXTOBJ": SELECT;
catalog sql object "<your BW schema name>"."RSDAREAT": 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;
catalog sql object "<your BW schema name>"."RSHIEDIR": SELECT;
catalog sql object "<your BW schema name>"."RSHIEDIRT": SELECT;
catalog sql object "<your BW schema name>"."RSTHIERNODE": SELECT;
catalog sql object "<your BW schema name>"."RSDAREA": SELECT;
catalog sql object "<your BW schema name>"."RSDAREAT": SELECT;
catalog sql object "<your BW schema name>"."RSDAREA": SELECT;
catalog sql object "<your BW schema name>"."RSHIEDIR": SELECT;
catalog sql object "<your BW schema name>"."RSHIEDIRT": 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;
} |
...