...
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:
/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.
| 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;
} |
...