cancel
Showing results for 
Search instead for 
Did you mean: 

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

04-17-2024 10:02 AM
tarrandurham Explorer
2599 views 4 comments
0 Likes
SAP Managed Tags
Labels
cloudDatasphere
Subscribe

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

0 Likes
View Entire Topic
cardoso
Product and Topic Expert
Product and Topic Expert

Hello, 

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

You need to use Agent Messaging user, not DBADMIN. 

BR.
Ismael