Versions Compared

Key

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

...

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;

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

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

}

...