Skip to Content
0

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

Nov 22, 2017 at 10:12 AM

704

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Maria Trinidad MARTINEZ GEA
Dec 06, 2017 at 06:59 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded