Grant SELECT privileges on schemas of the used data foundation tables to user "_SYS_REPO"
If you get the error message insufficient privileges while activating any modeling views in SAP HANA. Then you have missed a step after creating a Schema
CREATING SCHEMA IN HANA DATABASE.
Error Message :
Short Text
Insufficient privileges - not authorized
Cause
User is not authorized to deploy attribute view
Recommendations
Grant SELECT privileges on schemas of the used data foundation tables to user "_SYS_REPO"
Error Message
Repository: Encountered an error in repository runtime extension; Deploy Attribute View: SQL: transaction rolled back by an internal error: insufficient privilege: Not authorized
Create view DDL statement: CREATE COLUMN VIEW "_SYS_BIC"."HANA_SA/COLOR_LOOKUP" TYPE JOIN WITH PARAMETERS ( joinIndex = "HANA_ECC"."COLOR_LOOKUP", joinIndexType = 0, viewAttribute = ('ARTICLE_COLOR_LOOKUP_ID', "HANA_ECC"."COLOR_LOOKUP", "ARTICLE_COLOR_LOOKUP_ID", '', 'default', 'attribute', '', 'HANA_SA/COLOR_LOOKUP$ARTICLE_COLOR_LOOKUP_ID'), viewAttribute = ('ARTICLE_ID', "HANA_ECC"."COLOR_LOOKUP", "ARTICLE_ID", '', 'default', 'attribute', '', 'HANA_SA/COLOR_LOOKUP$ARTICLE_ID'), viewAttribute = ('COLOR_CODE', "HANA_ECC"."COLOR_LOOKUP", "COLOR_CODE", '', 'default', 'attribute', '', 'HANA_SA/COLOR_LOOKUP$COLOR_CODE'), view = ('V_COLOR_LOOKUP', "HANA_ECC"."COLOR_LOOKUP"), defaultView = 'V_COLOR_LOOKUP', 'REGISTERVIEWFORAPCHECK' = '1' ) NO STRUCTURED PRIVILEGE CHECK
Solution :
GRANT SELECT ON SCHEMA <SCHEMA NAME > TO _SYS_REPO WITH GRANT OPTION;
3) Now Save and Activate the Attribute view. Check the job log, will be completed Successfully without errors.
Nice blog with good explanation on SAP Training modules..
ReplyDeleteWow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also for more info
ReplyDelete