Skip to Content
avatar image
-1
Former Member

User is missing privilege EXECUTE SYS.CREATE_INTERMEDIATE_CALCULATION_VIEW_DEV

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Sep 06, 2017 at 11:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 07, 2017 at 06:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 07, 2017 at 07:56 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 12, 2017 at 11:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded