The SELECT permission was denied on the object 'EntityView', database 'Fashion_MSCRM', schema 'dbo'.

Sometimes, when you create or import a new CRM Organization, the new CRM Organization does not work..

If you take a look in Event Viewer, you will see a message like : The SELECT permission was denied on the object 'EntityView', database 'Fashion_MSCRM', schema 'dbo'.

For this, you can give explicit permissions on that object :

GRANT SELECT ON dbo.EntityView
TO [CRMReaderRole]
GO


Or, if you give that permission, and its still requires more permissions, for other objects, you can do it like :

EXEC sp_addrolemember N'db_owner', N'CRMReaderRole'
GO