Question Status

Suggested Answer
Ankit Shah asked a question on 30 Mar 2015 10:12 AM

Hello everyone,

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?

Thanks,
Ankit

Reply
Suggested Answer
Guido Preite responded on 30 Mar 2015 10:34 AM

With CRM Online you don't have Filtered Views.

Reply
Ankit Shah responded on 30 Mar 2015 11:13 AM

Hello Guido,

Thank you for the quick response.

Can you please confirm then how it fetching the user specific data in CRM online?

Thanks,

Ankit

Reply
Suggested Answer
Scott Durow responded on 30 Mar 2015 3:46 PM

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,

Scott

Scott Durow

Read my Blog   |  Follow Me on Twitter  |  Rockstar365

Reply
Suggested Answer
Guido Preite responded on 30 Mar 2015 10:34 AM

With CRM Online you don't have Filtered Views.

Reply
Suggested Answer
Scott Durow responded on 30 Mar 2015 3:46 PM

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,

Scott

Scott Durow

Read my Blog   |  Follow Me on Twitter  |  Rockstar365

Reply