Skip to Content
0

Getting insufficient privilege 258 error when doing data preview on Calculation view model.

Apr 04, 2017 at 01:41 PM

20

avatar image

I built a view in my schema based on two tables from another schema:

Example: Create view from SchemaA.Table1 etc store the view in SchemaB.

Grant Select to _sys_repo on SchemaB and SchemaA.

Grant Execute to _sys_repo on SchemaB.

Incorporate the new view into a calculation view and when I do data preview I get the error.

I tried just putting the (table)view in Calculation View model and the first time I activated it and previewed the data I got data back. The next time I ran it I got the insufficient privilege error.

capture4.png (9.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers