While finding on Record-level security in MS Dynamics CRM, I looked into the TSQL of “FilteredAccount” view of my on-premise installation and have found the use of SUSER_SNAME() to fetch the executing user’s username which is the domain user. ... This is implemented in “[dbo].[fn_FindUserGuid]”
But, in case of CRM Online, the requesting user is a “Live” user unlike the domain user of on-premise. So, how the SUSER_SNAME() logic holds true for the filtered views.
Can anyone please advise?
With CRM Online you don't have Filtered Views.
My blog: www.crmanswers.net - Rockstar 365 Profile - Follow me on Twitter
Thank you for the quick response.
Can you please confirm then how it fetching the user specific data in CRM online?
To query data in CRM online you use fetchxml - this will trim the records according to the current authenticated user identity when using SSRS reports or the Webservices. If you have 'act on behalf of another user' rights - you can also pass a UserId on the webservice call and return data for that user.
See msdn.microsoft.com/.../gg309629.aspx for more information.
Hope this helps,
Read my Blog | Follow Me on Twitter | Rockstar365