How to Grant Rights to Create Analytic View?

[Former Member]

I have attempted to create an analytic view when logged onto the SAP HANA Studio as the SYSTEM user connected to an SAP HANA One DB instance and I did not have the necessary rights.  I tried to grant the right below, which was mentioned in the SAP HANA Academy video, but could not.  I am on revision 38 on both the SAP HANA One DB and HANA Studio.  What do I need to do to be able to grant this type of right?  Are there other rights I need to have to be able to create an analytic view as the SYSTEM user?  Do I need to logon to SAP HANA One DB as a different user than SYSTEM to do this?

Command used to try to grant select right (when logged on as SYSTEM user):

grant select on schema demo to _SYS_REPO with grant option;

Error Received when running the command:

Could not execute 'grant select on schema demo to _SYS_REPO with grant option'

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

I appreciate any help on this, as I am not able to create analytic, attribute, or calcuation views due to the lacking rights at this time.  I can create tables and populate the tables as the SYSTEM user.

[danielculp]

Hi Mark,

The owner of schema 'demo' has to grant the rights. Can you confirm, that SYSTEM is the owner of 'demo'?

Best Regards

Daniel