Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Can we delete records form PrincipalObjectAccess table for the following condition by execute delete command on POA table
for (1) AccessRightsMask=0 and InheritedAccessRightsMask=0
(2) changedon is NULL
In which scenario changedon column is NULL ?
If the recors have the AccessRightsMask and InheritedAccessRightsMask = 0 then they should be automatically picked up by the deletion service and removed from the system. This is an async maintenance job that runs every 24 hours (see blogs.msdn.microsoft.com/.../crm-2013-maintenance-jobs)
I'd check if there were any errors when the deletion service ran ( SQL Timeouts, etc.) and address those.
Also, i would advise not to make any operations directly on the CRM DB as this is unsupported and can leave the DB in a faulted state (cause orphaned records if the references aren't properly disposed of)
I have another concern like, In my POA table there are lot of records which have changedon is NULL , Can i delete these records or In which scenario changedon value is NULL ?
This is a good question. I don't know why they would have changedon NULL. Could it be possible that someone altered the database directly in the past? Still, even if the changedon is NULL i don't think this should in any way influence the POA behavior (meaning that permissions are not granted).
I would test this scenario and see if the sharing permissions for a record having the changedon = NULL are not respected. In that case i would reach out to MS Support directly for assistance for cleaning that up.
Business Applications communities