Can not create Calculation Views on HANA MDC Trial

[former_member188673]

Hello,

I have been trying to create a simple calculation view (in Eclipse) by joining and aggregating two column store tables in HANA MDC trial instance. When I am trying to activate the CV the activation job terminates with error and following message is displayed in the job log-

Short Text

  Insufficient privileges - not authorized

Cause

  User is not authorized to deploy attribute view

Recommendations

  Grant SELECT privileges on schemas of the used data foundation tables to user "_SYS_REPO"

Database user for this activity has following roles -

Role	Description
SAP HANA Web-based Development Workbench
sap.hana.xs.ide.roles::EditorDeveloper or parent role sap.hana.xs.ide.roles::Developer	Use the Editor component of the SAP HANA Web-based Development Workbench.
sap.hana.xs.debugger::Debugger	Debug server-side JavaScript code
SAP HANA XS Administration Tool
sap.hana.xs.admin.roles::HTTPDestViewer	View HTTP destinations.
sap.hana.xs.admin.roles::HTTPDestAdministrator	Full access to HTTP destination configurations (display and edit).
sap.hana.xs.admin.roles::TrustStoreViewer	Read-only access to the trust store, which contains the server's root certificate or the certificate of the certification authority that signed the server’s certificate.
sap.hana.xs.admin.roles::TrustStoreAdministrator	Full access to the SAP HANA XS application trust store to manage the certificates required to start SAP HANA XS applications.

It seems to me it is due to some missing privilege/role. Can somebody please guide me how I can fix this problem?

Thanks.

Tapas.

[Murali_Shanmu · Accepted solution]

Hi Tapas,

Which user are you using to create these objects ?  You will need to issue the below statement to allow activation of the objects.

GRANT SELECT ON SCHEMA <schema Name> TO "_SYS_REPO";

Cheers,

Murali.

[former_member188673 · Accepted solution]

Many thanks Murali. Now I can activate the CVs in MDC instance. But now I am facing another privilege related issue. When I am trying to display the content of the CV using Data Preview function it says-

Error executing the query

Error: SAP DBTech JDBC: [258] (at 137): insufficient privilege: Not authorized

Earlier we used to invoke HCP procedure HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS for getting necessary privilege. But this procedure no longer exists in MDC. Not sure what else I have to do display CV content.

[Murali_Shanmu · Accepted solution]

Hi Tapas,

With MDC, you longer need to invoke those HCP procedures for this purpose. Which user are you using to create these objects and are you creating CV's which query some tables in another schema ?

I use the SYSTEM user to create a CV. I am able to preview the data without any issues.

Try creating a role in the Security section and provide SELECT privileges for CVs and other objects in the tab "Object Privilege". Assign this new role to your user.

Cheers,

Murali

[former_member188673 · Accepted solution]

Hi Murali,

Thank you again for your help.

I am not using SYSTEM user for creating and consuming CVs. Instead I have created one DB User as described in the following cloud documentation link-

SAP HANA Cloud Platform

and assigned it with required roles as mentioned in the link-

Roles Required for Web-based Tools

Using this DB user I created some Column Tables in the default schema of the user and populated them with some sample data. Then created CVs on these Column Tables within a sub-package below "public". But I can not display the content of the CVs. I have tried both DB user as well as SYSTEM user. Every time it says insufficient privilege.

I am opening a separate discussion for this topic.

Thanks.

Tapas.