model_access not listed in hdbrole

[Former Member]

I was trying to Creating an SAP HANA XS Application using the following document SAP HANA Cloud Platform

I was successfully able to execute call

     "HCP"."HCP_GRANT_ROLE_TO_USER"('p1940811895trial.dev.myhanaXS::model_access','P1940811895').

I was trying to grant roles for P1940811895 but was not able to find model_access role .I've followed and completed all the steps successfully currently stuck here.

[tbieser · Accepted solution]

Hi Shashank,

you are probably executing this scenario using a HANA Trial Instance on the HANA Cloud Platform. These instance do not offer access to all available HANA features. In particular you will not be able to freely grant any kind of roles to any user. Instead, you are only allowed to grant roles that you have created yourself. This is why you need to call the procedure that you have successfully executed: This procedure makes sure that you grant only roles that you created yourself.

In short: Everything is fine, works as expected

Should you have interest to explore the full capabilties of HANA without any limitations, you might want to have a look at the starter edition available in the SAP Markeplace.

Best,

Thomas.