Skip to Content
Oct 16, 2019 at 07:35 AM

Data Warehouse Cloud connection with DPAgent fails with Insufficient Privileges

340 Views Last edit Oct 16, 2019 at 09:06 AM 2 rev

Has anybody tried that yet?

When I want to register the DPAgent in the Hana using the provided login, I get the error "Insufficient Privileges, select * from public.EFFECTIVE_PRIVILEGES".

Anybody seen that?

Steps to reproduce:

  • In the Home screen, click on the administration button (left menu, very bottom).
  • Create new Agent Communication Credentials
  • Go to the DPAgent config tool and use the created credentials, here DP_MSG_WDAGENT
  • Login succeeds obviously but the user does not have enough privileges to read the Hana data dictionary.