Authorization Issue while activating the views in HANA Studio

[Former Member]

Hello Folks,

Recently i have got access to SAP HANA Sandbox and trying the do some scenarios.

But while i was activating the Analytical views i have got the error that "No authorization to execute DDL command"

One analysis i found that i need to get GRAND access to do the all operations.

I have given with one with one user SYSTEM, where i could not change this privilages because both are identical user names ( means i am trying to change my user privilages with same user name).

Please let me know how to get the access to all operations in SAP HANA Sandbox.

Thanks,

Krishna

[Former Member]

This message was moderated.

[henrique_pinto]

Try to run this command with the user that owns the schema of the tables underneath your analytic view:

GRANT SELECT ON SCHEMA <User_Name> TO _SYS_REPO WITH GRANT OPTION;