VIEW Permissions
I can take that same user and query every table that makes up the query just fine. I can copy the entire query for the view and run it as the user but when I try to run the new view I get the 01031 error. I granted SELECT on the new view to the user and the user still can’t return rows. I can do a describe of the view using the user and it will show me everything about the view but will not let me see the data.