insufficient privilege - while grant

[missile04]

I am new to SAP BTP.

I have created one user provided service instance.

getting this error insufficient privilege: Detailed info for this error can be found with guide '18D2CF9536D5D64998CFD68E7D65BECA'

[BiserSimeonov]

Hello Khaleel,

Thanks for raising your question. Just to understand better: can you please describe which BTP service / application you use and what you would like to achieve?

Kind regards,

Biser

[gregorw]

HI Biser,

looks to me like authorisations for SAP HANA Cloud.

CU
Gregor

[gregorw]

Khaleel you should adjust the tags accordingly

[Dinu]

I assume you are trying to access a schema rom HDI container. You can find a tutorial for what you are trying to do.

You can refer to the troubleshooting section in tutorial for figure out what has gone wrong. Essentially it is the following statement. You can find an app for this in HANA DB Cockpit as well.

 call SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS ('<GUID>', ?)

The issue is probably a missing grant or admin option to the role or user in the previous step.

CREATE ROLE CCROLE;
grant SELECT, UPDATE, INSERT, DELETE, EXECUTE, SELECT METADATA ON SCHEMA "PLAIN" TO CCROLE with grant option;
grant CCROLE to PLUSR with admin option;