a month 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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
9 | |
8 | |
6 | |
6 | |
6 | |
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.