provide access to view external system

[former_member207019]

Dear All,

I have created the DB view using sql statement on HANA system.

I would like to give the access to it to external system i.e. ECC.

So when I am trying to call this view using ECC tcode, It is trying to access via secondary db connection.

Then it is giving an issue, saying you have no access privileges.

How to provide an access to view from external system.

Regards,

Jo

[Bojan-lv-85 · Accepted solution]

Hello Jo,

basically you need to make sure the HANA user you are accessing the view with has permissions to access the view. I assume you are connecting to the HANA instance via the user maintained under the DEFAULT key in the hdbuserstore. Try to consume the view in HANA Studio (SQL Editor) with the same user and you should get the same error. You need to grant the SELECT privilege on the _SYS_BIC schema and eventually on the schema of the foundation tables.

BR, Bojan