FBL3H access error from ECC system

[Former Member]

Hi,

We are trying to access FBL3H transaction from our ECC system which will fetch data from HANA system.

ECC and HANA are connected via Secondary DB connection and tables are getting replicated through SLT system

ECC --> SLT --> HANA replication is present and Secondary DB connection is also working fine.

While accessing FBL3H we are getting authorization issue as shown below. The user maintained in DB connection has all the read roles and privilieges like PUBLIC, MONITORING, MODELLING, CONTENT_ADMIN and many more standard roles.

Can any body assist me in solving this issue, exactly which role is missing over here.

Thanks & Regards,

Sheetal

[abhishek_singh11 · Accepted solution]

Hi Sheetal,

SAP Note 1761917 should resolve the issue

Resolution

1. Make sure _SYS_REPO has privilege SELECT WITH

GRANT OPTION for the schemas used. In order to grant _SYS_REPO this privilege

you can execute the following statement:

GRANT SELECT ON SCHEMA <YOUR_SCHEMA> TO _SYS_REPO WITH GRANT OPTION;

2. Make sure the user activating the Object has at

least SELECT privilege over the schemas used within the scenario. SQL

statement to grant this privilege would be:

GRANT SELECT ON SCHEMA <YOUR_SCHEMA> TO <USER_THAT_WILL_ACTIVATE_ANALYTIC_OBJECT>;

3. Make sure all the dependencies of the Analytic

Object to be activated is contained in the Analytic Privilege assigned to the

user that will actually activate the Main Analytic Object.

DO NOT USE SYSTEM User !!!

Thanks Much,

Abhishek

[Former Member · Accepted solution]

Hi Abhishek,

thanks for your quick reply.

The note helped in solving the issue.

The problem was the privilege to user activating the object.

Thanks & Regards,

Sheetal