SAP TechEd Discussions
Join the conversation around SAP TechEd! Discuss details of technical sessions and workshops and anything else conference related.
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem granting privileges using user-provided service

surreyhobbit
Explorer
0 Kudos
593

Tutorials: https://developers.sap.com/tutorials/hana-cloud-collaborative-database-development-6.html
--------------------------

I am following the Teched tutorial "hana-cloud-collaborative-database-development" and am having issues in step 2 of module 6. After adding the `generic.hdbgrants` file I am getting an error during deployment:

Processing grants files...
 Processing "src/generic.hdbgrants"...
  Using grantor service "UPS_GENERIC" of type "sql"
Deployment ended at 2021-12-13 14:30:06
Error: authentication failed
grantor service: "UPS_GENERIC", type: "sql", user: "UPS_GRANTOR"
file name: src/generic.hdbgrants<br>

What could be the issue here?

2 REPLIES 2

martinstenzig
Contributor
0 Kudos
323

Steffen,

One of the most likely causes is that you created a dedicated grant user and you have not changed the initial password. I usually use the following two lines to prepare a user to be used as a grantor user.

CREATE USER XXX_GRANTOR_USER PASSWORD XXX123# NO FORCE_FIRST_PASSWORD_CHANGE
GRANT "CREATE VIRTUAL TABLE","CREATE VIRTUAL FUNCTION", "CREATE REMOTE SUBSCRIPTION", "PROCESS REMOTE SUBSCRIPTION EXCEPTION", "ALTER", "DROP" ON REMOTE SOURCE "<Your remote source name>" TO XXX_GRANTOR_USER WITH GRANT OPTION;

surreyhobbit
Explorer
0 Kudos
323

Martin,

thanks for your response. As per the tutorial I indeed created a dedicated grant user, but it also has the option of not having to change the password.

This is what i did:

create user UPS_GRANTOR password "XXXX" NO FORCE_FIRST_PASSWORD_CHANGE;
grant  "genericRoleForOO" to UPS_GRANTOR WITH ADMIN OPTION;
grant  "genericRoleForAP" to UPS_GRANTOR WITH ADMIN OPTION;

I am wondering if maybe there is something missing in the tutorial. I traced my steps back and I did all previous steps as described.