CODEWITHSUNDEEP
dynamics-crm-2011
Hatch
Hatch

Reputation: 605

Why does my select statement on a filtered view return 0 records although user has CRM permissions?

I have a Dynamics CRM 2011 on-premise installation and I want to retrieve records from the FilteredAccount view. I do this in the context of a domain user that is also an enabled CRM user with CRM read permissions.

Previously, this has worked fine, but suddenly this has stopped working, i.e. the query now yields 0 records. The same query executed in the context of the CRM deployment administrator user I can query the view just fine and I can also see that the user (for which the select statement returns 0 records) is present in the FilteredSystemUser view with access mode == read. That user is also a member in the correct ActiveDirectory CRM Reporting Group.

From what I can see, this user should have all the necessary permissions. What else could have an impact on the records returned from the query?

Upvotes: 1

Views: 3897

Answers (2)

Tsolmon
Tsolmon

Reputation: 21

For my situation, the CRM user's domainname was somehow changed, like mydomain\user_1 to mydomain\user1.

Resolution is to go to crm database, find systemuser view, change the domainname column value to one supposed to be.

Upvotes: 2

Hatch
Hatch

Reputation: 605

It turns out that the user in question did not have a security role assigned. Re-assigning the correct security role fixed the problem. I am however clueless as to what could have caused this.

Upvotes: 1

Related Questions