Building up a view in own schema

[Former Member]

Hi guys,

I just started building up a regular view in my own schema. So its basicly just a couple of tables and joins. Unfortunately I´m not able to either save the view inside the HANA system or consume the view in the Studio. Studio says: No connection to databse. But the connection is definetly available. Is this probably because of my user rights??

Regards, Christoph.

[Former Member · Accepted solution]

Hi Christoph,

Did you try clicking the connection button?

Also, when you create a new schema don't forget to run the following:

GRANT SELECT ON SCHEMA <your_schema> to _SYS_REPO WITH GRANT OPTION;

Cheers

Jody