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,