2 weeks ago
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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/a9b579afd5ba4...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
11 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.