'Insufficient privileges - not authorized' error during attribute view activation

[Chandan]

Hi All,

I am using HANA development edition instance on Microsoft Azure. I have created few table. After that I created an attribute view and tried to activate that. But I am getting 'Insufficient privileges - not authorized' error during activation. I am doing all these development from CODEJAMMER user provided by SAP CAL.

Can someone please let me know the probable reason for this?

Thanks,

Chandan

[RashmiAcharya · Accepted solution]

Hi Chandan,

Have you run the below grant select querry for the schema in which you created the tables?

GRANT SELECT ON SCHEMA <your_schema_name> TO _SYS_REPO WITH GRANT OPTION;

If grant select authorization is not there for _SYS_REPO user for the schema you are using, activation will fail with 'Insufficient privileges - not authorized' error.

Regards,

Rashmi