Skip to Content

Unable to activate Open ODS - User is not authourized

Hi,


During the creation of Open ODS view, I am unable to activate my object. I think it might be due to missing HANA Authourization. Does any one

know how I can resolve it and which authourization that is required.

- Bhat

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Dec 07, 2015 at 12:05 PM

    Hi, I would like to resolve the issue and was wondering if anyone knows how it can be resolve. Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2015 at 11:11 AM

    Does the user you are using have the SELECT access on the source object on which you are creating ODS view?

    Regards,

    Krishna Tangudu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2016 at 12:15 PM

    Hi Guys,

    I'm facing the same issue. Have you found any solution?

    Regards

    Amanda

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 17, 2016 at 07:23 PM

    i have exactly the same error when activating ODS view .

    Can you let me know how did you resolve it ?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 18, 2016 at 04:35 AM

    Hi All,

    I too face same Issue.

    Regards,

    Muthuram

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Bhat,

      I am able to resolve this Issue now 😊.

      Assume "DATA_BODS" is External schema and

      We have to create Open ODS Views on top of Tables from "DATA_BODS" schema.

      Standard HANA DB User for BW application will be SAP<SID>. Assume User is "SAPH01"

      The point is that "SAPH01" user need select and Execute access for "DATA_BODS" schema.

      So Open ODS View on top of the tables from schema can be activated successfully.

      Execute the following SQL Queries using User, who is Owner of the schema "DATA_BODS".

      GRANT SELECT ON SCHEMA DATA_BODS TO SAPH01 WITH GRANT OPTION

      GRANT EXECUTE ON SCHEMA DATA_BODS TO SAPH01 WITH GRANT OPTION

      Open ODS will be activated successfully.

      Regards,

      Muthuram

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.