I had written a new view in the main Lilie database which listed some data that was taken from the Episodes view. It worked fine for me in MSSM, Excel and Access, but when other users tried to run the queyr, they got the column headers (so that the query was running) but not the records (i.e. nothing was selected)
At first I thought it was database permissions. Becauase I had created the view, perhaps other people did not have the rights to execute it or run a select on it so I GRANT ed full permissions to all users, but this did not solve the problem.
It turns out that the Episodes view checks that the logged in user has the rights to access specific episdoe types at specific locations and that the UserEpisode table had not been completed when the user records were created. I added the correct types against the user names and the query ran as expected
No comments:
Post a Comment