You’re offline. This is a read only version of the page.
585
Hi
What will happen in case i delete the records in principalobjectaccess
*This post is locked for comments
Hi Abood,
I am using MS D365 Online and I want to delete some records or rows from POA so that I can able to minimize the size. Can You tell me the steps to do that?
Regards,
Sougata
Hi,
As others said POA table stores sharing / access data and you never delete anything with SQL commands.
But it also has some buggy structure (in MS CRM 2011), sometimes platform does not remove sharing record when you remove share or delete main entity.
One of my customers was having similar problem with POA table in CRM 2011. We delete buggy rows from table with SQL commands with Microsoft Support (PFE) team's help.
Maybe you should contact them about this issue.
I'm sorry for the miss understating here
My question is What will happen in case i delete the records in principalobjectaccess and how can i delete them
it's almost 5 million records and it's tacking a lot of space and the performance is not good
i'm using CRM online
Sorry
but you haven't mentioned in your post that you want to know how to delete and asked what will be if you deleted that data.
Also you haven't mentioned in post that you're online.
So I believe I answered your question ;)
It's taking space
The records count almost 5 million
May be he wants to minimize POA table size by removing some records.
PrincipalObjectAccess table store the sharing/access details of the record. There is mask value which specifies what all rights does a user/team has on a record.
Deleting record in table is unsupported and can cause unexpected behavior in CRM.
What is the purpose you are looking for deleting the records?
The better way to be unshare the record from user level sharing and start using access team/team ownership to control security.
Thanks,
PS
Sorry
but the link you provide is not giving a way to delete
and also all the solution in the web cannot be applied on Online version
Based on the function of records in those table you will delete all the shares done. Check this thread for additional clarifications - community.dynamics.com/.../218848
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (