Child pages
  • RS2HANA_CHECK
Skip to end of metadata
Go to start of metadata

Transaction RS2HANA_CHECK provides an option for checking all of the required prerequisites for a successful replication of the BW authorizations based on SAP HANA analytic privileges. If prerequisites are not met, you can detect this in an error message in the displayed log. Solution options are described in the long texts of the relevant error messages.

 

 

CheckDescriptionlink or details available in SAP notes or SAP KBAtype required
General SAP HANA Priviliges
(Select, Execute on Schema & Package)

Specif user has the general priviles to access the view

  • SELECT on schema _SYS_BI
  • EXECUTE on procedure REPOSITORY_REST
  • REPO.READ on .REPO_PACKAGE_ROOT
  • REPO.READ for the package in which the required SAP HANA views are generated (see transaction RS2HANA_VIEW)

 

 User specific, not InfoProvider specific BW user
Check Privileges of SAP<SID> UserChecks whether the SAP<SID> user has the following privileges that are generally required to generate views in SA P HANA from BW
  • System privilege ROLE ADMIN
  • System privilege STRUCTUREDPRIVILEGE ADMIN
  • EXECUTE on procedure TRUNCATE_PROCEDURE_OBJECTS
  • EXECUTE on procedure GET_PROCEDURE_OBJECTS

in case SAP HANA Change Recording Management Functionality is used (see note 2174750)

  • REPO.MODIFY_OWN_CONTRIBUTION
  • REPO.MODIFY_CHANGE
 SAP<SID> specific Checkbox "Include SAP<SID> user (SAP<SID>) must be selected
Existence and Assignment of SAP HANA Procedure(s)Checks whether the required procedures exist and that the specified user has all required procedures assigned to access the generated SAP HANA view of the provided InfoProvider. It is checked if the user has the EXECUTE privilege on the generated procedures  BW user/InfoProvider specificInfoProvider & BW User
Existence and Assignement of SAP HANA Privilege(s)Checks whether the required privileges exist and that the specified user has all required SQL analytic privileges assigned to access the generated SAP HANA view of the provided InfoProvider. It is checked if the generated analytic privilege is granted to the user BW user/InfoProvider specificInfoProvider & BW User
Existence and Assignement of SAP HANA Role(s)Checks whether the required roles exist and that the specified user has all required roles assigned to access the generated SAP HANA view of the provided InfoProvider. It is checked if the generated role is granted to the user BW user/InfoProvider specificInfoProvider & BW User
Existence of Filter String(s)Checks whether the filter string that represents the BW authorizations is available in table RS2HANA_AUTH_STR KBA 2390443BW user/InfoProvider specificInfoProvider & BW User
Session Client of SAP HANA User(s)Checks whether mapped SAP HANA user of the provided BW user has a correct session client set. That is the current BW client. BW user specificBW User
RFC destination for After-Importduring the transport a client change is necessary therefore transaction RSTPRFC should be maintained in the transport target system https://wiki.scn.sap.com/wiki/x/lJ5xFw  RFC destionation with client, user and password
  • No labels