Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
languagesql
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;
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;

--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;

}

...