Queries in IFD environment

We are migrating our application开发者_运维问答s from on-premise to IFD. We have some webpages that creates some kind of queries to the CRM Views (ie Select * from account). These queries work well in on-premise environment but when we run on IFD environment we have this exeception

Login failed for user 'NT AUTHORITY\IUSR'.

How can we do this in IFD, being sure that the query returns only the rows the user has permission?

when moving over from on premise you have to start "impersonating" users as you are not working on active directory anymore...

first of all you should NEVER be using the account table, you should be using the filteredaccount views as this is the supported way.