In SAP HANA Studio, you want to open the data preview from one of the Views in the database. Unfortunately, below error message coming out,
Solution
Use SQL console and execute the following query. The query will grant the select statement on the schema for _SYS_REPO and your user identity.
grant select on schema [THE_SCHEMA] to _SYS_REPO with grant option;
grant select on schema [THE_SCHEMA] to [YOUR_USER];
Alternatively, you can use HANA studio administration tool. Look for _SYS_REPO user and add the schema from the Object Privileges. Now, assign the SELECT privilege to the _SYS_REPO. Proceed the same for your own user. Save your changes!
SAP Note Reference
- 1612696 – “Invalidated view” Error When Using Analytical Views
- 1852628 – When exploring and Information Space based on HANA view getting error “Insufficient privilege: Not authorized : line 1 col 179…”
- 1761917 – Error “user is not authorized” or “invalidated view” when executing or activating an Analytic Object
