Question Re: SAP Datasphere DBADMIN and Data provisioning agent is... in Technology Q&A

SAP Datasphere DBADMIN and Data provisioning agent issue (AGENT ADMIN and ADAPTER ADMIN)

tarrandurham — Wed, 17 Apr 2024 08:02:41 GMT

Hello all,

in regard to SAP Datasphere and SAP HANA Data Provisioning Agent:

when we install the provisioning agent and connect the DB User from the Space Administration page to the provisioning agent, we are getting the issue:

Missing privileges for Agent Admin HANA user: S4HC_DATA_MIGRATION#DB_ADMIN [..]Ensure that the system privileges AGENT ADMIN and ADAPTER ADMIN are granted to agent admin HANA user.

How are we to grant these privileges to a Database user? in the SQL console we don't have sufficient privileges to do these grants.

Could not execute 'GRANT AGENT ADMIN TO S4HC_DATA_MIGRATION#SYSTEM' Error: (dberror) [258]: insufficient privilege

Is there a DBADMIN superuser for all Spaces on the Datasphere? Or how do we grant these privileges?

Best regards

T. Durham

Re: SAP Datasphere DBADMIN and Data provisioning agent is...

tarrandurham — Wed, 17 Apr 2024 08:13:08 GMT

This is the documentation for the roles, but not sure how to grant them on the Datasphere.
https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/7952ef28a6914997abc01745fef1b607/a9b579afd5ba45b3889dd69db985b7d6.html

Re: SAP Datasphere DBADMIN and Data provisioning agent is...

TuncayKaraca — Wed, 17 Apr 2024 16:05:04 GMT

Hi T. Durham,

I don't think you need to connect the DB User from the Space Administration page to the provisioning agent.

If your purpose is to configure DP Agent for Datasphere, you may follow:

Regards,
Tuncay

Re: SAP Datasphere DBADMIN and Data provisioning agent is...

murllimaraati — Fri, 19 Apr 2024 10:17:23 GMT

Hi, Check out this step by step video on SAP Datasphere and DP agent configuration https://www.youtube.com/watch?v=lMug4dQeecE&ab_channel=MurlliMaraati

Hope this will help.

Best Regards,

Murlli Maraati

Re: SAP Datasphere DBADMIN and Data provisioning agent is...

cardoso — Wed, 01 May 2024 21:19:51 GMT

Hello,

Follow Datasphere's DPAgent installation guide:
https://github.com/SAP-samples/datasphere-content/blob/master/SAP%20Data%20Warehouse%20Cloud%20-%20DP%20Agent%20Installation%20V2.pdf

You need to use Agent Messaging user, not DBADMIN.

BR.
Ismael