I have succeeded in activating HANA views(Attribute,Analytic and Calculation views), but cannot preview the data of these data models.
These views are saved in schema "_SYS_BIC" as column views, so I guess that I need SELECT privilege on schema "_SYS_BIC".
I cannot assign any role to myself since grantor and grantee are the same, so I create a role file "developerAdmin" as below
catalog schema "_SYS_BIC": SELECT;
Then in SQL console,
CALL "_SYS_REPO"."GRANT_ACTIVATED_ROLE" ('ZGRY.00.test::developerAdmin','RYGAN'
Now when checking the authorization, I have the role "developerAdmin" assigned to myself. However, I still cannot preview the data model with following issue message:
Error: SAP DBTech JDBC: : insufficient privilege: search table error:  user is not authorized
In SQL console,
SELECT * FROM _SYS_BIC"."ZGRY.00.data/AT_CUSTOMER"
Still error message like
Could not execute 'SELECT * FROM "_SYS_BIC"."ZGRY.00.data/AT_CUSTOMER"' in 1 ms 637 µs .
SAP DBTech JDBC: : insufficient privilege: search table error:  user is not authorized
Any idea what is wrong with the authorization?
I do not even have MODELING role , should I have more roles?