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'smile

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

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
60
views
0
replies
1
followers
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft