Skip to Content
Jan 16, 2019 at 10:36 AM

Created a View but cannot Access it


Hi All,
We have a table USAGE created in HANA repository by .hdbdd file, the owner of the table is _SYS_REPO.

Later we create a view USAGE_V in on this table, the creator is SYSTEM.

When we try to access USAGE_V, SELECT * FROM USAGE_V, we fail with insufficient privilege error.

Both table and view are in schema ATT and our users have privilege to SELECT on ATT.

I am wondering why our selection fails in this case? Why it happens? And how can we fix it?

Thanks and best regards,