11-22-2017 10:12 AM - edited 02-04-2024 2:22 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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;
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.