on 04-04-2017 2:41 PM
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.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.