Hi Team,
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
role ZGRY.00.test::developerAdmin
{
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: [258]: insufficient privilege: search table error: [2950] 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: [258]: insufficient privilege: search table error: [2950] user is not authorized
Any idea what is wrong with the authorization?
I do not even have MODELING role , should I have more roles?
Thanks,
GRY