cancel
Showing results for 
Search instead for 
Did you mean: 

Data Warehouse Cloud connection with DPAgent fails with Insufficient Privileges

werner_daehn
Active Contributor
0 Kudos
414

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.
View Entire Topic
werner_daehn
Active Contributor
0 Kudos

Never mind. Of course I cannot login with the Messaging User into Hana.

Following this guide helped.

https://github.com/SAP-samples/data-warehouse-cloud-content-beta/blob/master/SAP%20Data%20Warehouse%...