CRM User Cannot Query Filtered Views

We ran into an issue where a valid CRM user could not run a particular report.  The root cause was that the user (who is a valid CRM user) could not query data out of the Filtered Views.

Further investigation revealed that after his CRM account had been created, his domain logon name had been changed in Active Directory.  However, in the SYSTEMUSERBASE table in the _MSCRM database, it was still the old login name.

By changing the login name field in the SYSTEMUSERBASE table to the new domain login name, the issue was corrected.

NOTE: take extra caution when directly modifying the CRM database.  Be sure you have a backup!

Comments

[henricus cox]

Jason,

New at this, so how do I edit that SYSTEMUSERBASE table?

Thanks!

[cisco training]

thanks for your information. but These days I am doing preparation of different online certifications and I found cisco training guide is the best helping source which is providing 100% authentic material. I also spend my extra time in surfing internet, listening music and playing games. After my exams I would like to join your group.