Skip to Content
-1

User is missing privilege EXECUTE SYS.CREATE_INTERMEDIATE_CALCULATION_VIEW_DEV

Sep 06, 2017 at 07:26 PM

458

avatar image
Former Member

Hi All,

I am facing the issue like "User KVCW721 is missing privilege EXECUTE for PROCEDURE/FUNCTION SYS.CREATE_INTERMEDIATE_CALCULATION_VIEW_DEV"

but i am not able to find the privilege in sap hana.

Can you please suggest on this.

Regards,

Prasad V

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Michael Healy
Sep 06, 2017 at 11:40 PM
0

Hi,

When you say you cant find the privilege....what exactly do you mean?

Find the owner of the procedure and get the owner to grant the EXECUTE privilege to KVCW721

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 07, 2017 at 06:39 AM
0

Hi Healy,

Thanks for the quick response.

I am not able find the procedure/function with that name "SYS.CREATE_INTERMEDIATE_CALCULATION_VIEW_DEV" and also not able to object privileges regarding this for granting "Execute" for usee KVCW721. we are seeing the data preview for each level of like projection , join .so we are getting this issue.

Regards,

Prasad V

Share
10 |10000 characters needed characters left characters exceeded
Michael Healy
Sep 07, 2017 at 07:56 PM
0

Hello,

I'm finding it difficult to understand what you are trying to say...

You say you cannot see/find the procedure named "SYS.CREATE_INTERMEDIATE_CALCULATION_VIEW_DEV"? Can you at least prove it exists?

You then say "we are seeing the data preview for each level of like projection , join .so we are getting this issue" which is some what contradictory to your comments suggesting you cannot see it....maybe I'm misunderstanding you here? Please provide some clear explanations with some screen shots perhaps?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Sep 12, 2017 at 11:36 PM
0

Hello,

You can just execute:

GRANT EXECUTE ON SYS.CREATE_INTERMEDIATE_CALCULATION_VIEW_DEV TO <USER_NAME>

CREATE_INTERMEDIATE_CALCULATION_VIEW_DEV has “_DEV” suffix, you cannot see it in the relative schema.

Regards,

CK

Share
10 |10000 characters needed characters left characters exceeded