cancel
Showing results for 
Search instead for 
Did you mean: 

Prevent error activating calculated view in new schemas: user is not authorized (2950)

vangelis_sanchoyerto
Participant
0 Kudos

When creating a calculated view for example in imported or new schemas we encountered the error:

Repository: Encountered an error in repository runtime extension;Model inconsistency. Create Scenario failed: The following errors occurred: user is not authorized (2950)

We solved this with the following grant command:

GRANT SELECT ON SCHEMA NEWDATABASE TO _SYS_REPO WITH GRANT OPTION;

The problem is what grant command or configuration should we use so in the future all new schemas or imported schemas get this privilege so we dont have to do this grant command manually each time?

In theory adding the Object Privilege: "GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT (_SYS_REPO)"

It should achieve this, but the problem keeps happening.

Accepted Solutions (0)

Answers (1)

Answers (1)

Trinidad
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Vangelis,

You will need to run the GRANT command on _SYS_REPO user for each new schema to be able to run calculation views on top of your tables.

Regards,
Trinidad.

former_member649972
Discoverer
0 Kudos

Can you tell me the detailed operation steps? Thank you

2780_2818_9397 make sure you run the following on Hana Studio (logged as SYSTEM or some other user with the correct granting permissions for the schema) and swap the SBODEMO for the name of the schema your calculated View uses.

GRANT SELECT ON SCHEMA SBODEMO TO _SYS_REPO WITH GRANT OPTION;