Skip to Content
avatar image
Former Member

SAP Hana - Data Preview of Attribute View fails

Hello,

I have an Attribute View created in my package, and it uses tables from my schema. I was able to Validate and Activate the Attribute view after using the following SQL:

GRANT SELECT ON SCHEMA "<SCHEMA_NAME>" to _SYS_REPO WITH GRANT OPTION;

But when I do a Data Preview of this Attribute View, and click on Raw Data, I get the following error:

Error: SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

(I'm doing this in SAP Hana Modeler in Eclipse)

How can I fix this error?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 25, 2015 at 10:05 PM

    I found a solution to my problem and I am posting it here.

    In order to do a Data Preview of Attribute views, you need to run the SQL (Call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS")  AFTER deleting all tables in your Dev schema. I was running it with tables still in my DEV schema, and hence it was throwing this error. The second part is that I need to recreate these tables in my NEO schema, and not the DEV schema. 

    After deleting my tables, I ran the SQL, and then recreated my tables in the NEO schema. Then I recreated my attribute view, and activated it. The _SYS_BIC schema started to show. And I could do a Data Preview of my Attribute Views.

    Hope this helps anyone who faces the same issue.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 06:58 PM

    Hi Nish,

    Try Show Authorization from context menu of SYS_BIC column view. You may get some hint what privileges you are missing.


    Regards,

    Chandu.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Chandra Sekhar

      Hi Chandu,

      Thanks for all your assistance so far.

      I don't have a System ID, as I'm running a local trial version of Hana on Eclipse (developer license). I'm on Mac OSX. The only ID that was given to me from SAP was this 'p...trial' ID. It appears like my trial ID does not have the required privileges which is causing all these authorization issues.

  • Oct 19, 2015 at 03:57 PM

    Hi Nish,

    Can you please look at this blog

    SAP HANA - How to create an Attribute View

    Thanks,

    Naga

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Naga,

      The steps in your blog have been followed but do not help in fixing this error. When I try the following SQL, I get an error saying user does not have access to a table. I even followed instructions from another forum and copied the tables from the DEV_... schema to the NEO_... schema. But still have the error.

      CALL "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS";


      p...trial.myhanaxs.hello/BERTHING_ATT_VIEW. User DEV_.... is not authorized for:  Object: Dim_Pumping_Type Schema: DEV_.... Type: TABLE

  • Oct 21, 2015 at 02:55 AM

    Try adding sys cp all analytical previlige to your id. You need this to run any view.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Naresh - thanks for your reply. I tried adding the _SYS_BI_SP_ALL privilege, but it says I'm not authorized to grant that privilege. See attached screenshot.

      Screenshot2.jpg (88.0 kB)
  • avatar image
    Former Member
    Oct 21, 2015 at 07:15 AM

    Execute below statement also.

    GRANT EXECUTE ON SCHEMA "<SCHEMA_NAME>" to _SYS_REPO WITH GRANT OPTION.


    Br

    Sumeet


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sumeet,

      I executed that SQL Statement before, and each time after making any change, It runs successfully, but the issue still remains. I'm still unable to Preview Data.