I have a Microsoft Dynamics database on-prem and I am going through the filtered views, if I query the views as any user aside from the sa account, I get 0 rows returned. I have a login that is mapped to the database as db_owner, I can see the database, tables, views, edit stored procs, etc. But if I select the top 100 rows I get 0 rows returned.
Any suggestions?
- Assigned db_owner, db_datareeader, db_datawriter
- Tried other logins