cancel
Showing results for 
Search instead for 
Did you mean: 

SAP HANA Cloud Trial account - Content - Insufficient privilege

darshansomaiah1
Participant
0 Kudos

Dear SCN members,

I am trying to use free trial HANA Cloud account mentioned in Open SAP https://account.hanatrial.ondemand.com but after creating an account and schema, I have added the account in HANA studio.

But in Contents folder, I am receiving an error as "Insufficient privilege (EXECUTE on REPOSITORY_REST)".

Hence, I cannot try the practice sessions provided.

Please suggest the solution or guide me if I have missed anything in the setup of an account.

Thanks in advance,

Regards,

Nachappa S

Accepted Solutions (0)

Answers (6)

Answers (6)

chandan_praharaj
Contributor
0 Kudos

I would suggest go through the below blog to setup a data base user and its requisite roles.

SAP HANA Cloud Platform

If you grant correct roles to your DB user,(create a new one) then you wont face the issue.

darshansomaiah1
Participant
0 Kudos

Hi Michael, Nagendra,

Thanks for the feedback. I tried it but it did not help due to insufficient privileges

Could you please provide suggestion on how to add the EXECUTE role to user DEV_****.

I have tried via HANA cock pit but it did not help.

I tried to execute the commands in HANA studio, but I do not have sufficient privileges.

Regards,

Nachappa S

narendra_verma
Explorer
0 Kudos

Can you provide , your login detail / password?

narendra_verma
Explorer
0 Kudos

Hi,

Run this command after activation  of information view and refresh catalog folder-

call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

darshansomaiah1
Participant
0 Kudos

Hi Nagendra, Michael,

I have tried the following SQL commands, but it seems I do not have authorization to execute the commands.


Please suggest

former_member183326
Active Contributor
0 Kudos

Again, you are missing the EXECUTE privilege on the _SYS_REPO.

You have to grant your user the EXECUTE privilege to the _SYS_REPO.

narendra_verma
Explorer
0 Kudos

Hi,

You have missing privilege , you can try an alternative as below -

Run following Command-

GRANT SELECT ON SCHEMA "YOUR_SCHAME"  TO _SYS_REPO WITH GRANT OPTION;

call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

Then go to _SYS_BIC Schema , and under Column_view folder , there will be your view available.

you can use data preview on your information view.

Thanks.

former_member183326
Active Contributor
0 Kudos

Try looking here

Your user is missing the EXECUTE privilege for the PROCEDURE/FUNCTION SYS.REPOSITORY_REST. (SYS_REPO)