BPC11 installation issue workaround

Issue: during the BPC11 installation procedure Install guide ask to grant in SAP HANA database “SELECT” permisions to BPC_User on BW schema using HANA Studio (apply SAP Note 2362807).

Problem is that BW schema is not available as far as BW is installed yet. To find this schema you need to finish BW installation but you can finish BW installation only by applying SAP Note 2362807.

So we’ve got a dead loop.

Workaround:

  1. Take a list of BW tables from Netweaver
  2. Make script of granting permissions using the list of BW tables (see the script below). Run it in SQL console or SQL window in SAP HANA Studio.
  3. Grant permissions better to system user SAPABAP1 instead of BPC_User.

 

2362807 – SAP HANA authorizations for BW metadata search/no results in search/input help for BW modeling tools

  • Object permissions
    • SELECT on BW schema with GRANT option
    • SELECT on tables mentioned in table RSOSTABLES. These include the following tables among others:
      • RSDIOBJ
      • RSOHCPR
      • RSOADSO
      • RSDAREA

SQL Script:

GRANT SELECT ON SAPABAP1.RSDAREAT                  TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOADSO                  TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOADSOLOC          TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOADSOT                  TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOOBJXREF         TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSLTIP                  TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSLTIPT                 TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSPLS_ALVL          TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSPLS_ALVLT        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOAPPL                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOAPPLT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSAPPL                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSAPPLT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSBOHDEST                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDAREA                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDCUBE                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDFDMOD                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDHAMAP                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDIOBJ                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDODSO                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSFBP                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSLPO                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOHCPR                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSQISET                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSLTIPXREF                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSWSPLREF                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDCUBEIOBJ        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDCUBELOC                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDCUBET                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSBOHDESTT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDFDMODT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDFDMOD_LOCAL        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSBKDTP                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSBKDTPSTAT        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSBKDTPT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSRREPDIR                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZCOMPDIR                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZCOMPIC                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZELTDIR                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZELTTXT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZELTXREF                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZGLOBV                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZRANGE                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSFBPFIELD                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSFBPSEMANTICS        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSFBPT                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDHAMAPT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOHCPRT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDIOBC                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDIOBCIOBJ        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDIOBCT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDBCHATR                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDBCHATRXXL        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDCHA                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDCHABAS                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDIOBJCMP                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDIOBJT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDKYF                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDTIM                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDUNI                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSQISETT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDODSOIOBJ        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSLPOT                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSADMINA                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSBASIDOC                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.T000                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.TBDLST                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDCUBEMULTI        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDODSOLOC                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDODSOT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZWOBJTXT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSZWVIEW                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDS                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSDST                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOSEGR                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOSEGRLOC                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSOSEGRT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSKSFIELDNEW        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSKSNEW                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSKSNEWT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSTRAN                        TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSTRANT                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSUPDINFO                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSRWBINDEX                TO  _SYS_REPO WITH GRANT OPTION;

GRANT SELECT ON SAPABAP1.RSRWBINDEXT        TO  _SYS_REPO WITH GRANT OPTION;

About the author: Dmytro Potapov

You must be logged in to post a comment.