0


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 :


1) Select the schema and open the SQL editor console.


2) Execute the following statement in the SQL editor.
   
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.



Post a Comment

 
Top