on 07-09-2016 3:57 PM
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
I would suggest go through the below blog to setup a data base user and its requisite roles.
If you grant correct roles to your DB user,(create a new one) then you wont face the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Run this command after activation of information view and refresh catalog folder-
call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.