HCP Trail :: HCP.HCP_GRANT_ROLE_TO_USER error.

[Former Member]

Getting following Error while trying to Grant role to user for OData service . Need urgent solution

I am following PersonsList SAP HANA XS Web IDE Tutorial

As per Tutorial need to execute following Statement in Catalog.

call HCP.HCP_GRANT_ROLE_TO_USER('pXXXXXtrial.ashxs.perslist.roles::user','pXXXXX')

Statement: 'call HCP.HCP_GRANT_ROLE_TO_USER('pXXXXtrial.ashxs.perslist.roles::user','pXXXX')'.Error calling procedure: insufficient privilege: [258] "HCP"."HCP_GRANT_ROLE_TO_USER": line 14 col 11 (at pos 849): [258] (range 3) insufficient privilege exception: insufficient privilege: [258] "HCP"."SYNCHRONIZE_HCP_ROLES": line 22 col 12 (at pos 1518): [258] (range 3) insufficient privilege exception: insufficient privilege: Not authorized

[Former Member · Accepted solution]

It got solved.

I recreated the HANA instance and all worked fine after that.