Notifications
Announcements
No record found.
Hi
What will happen in case i delete the records in principalobjectaccess
*This post is locked for comments
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
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
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
May be he wants to minimize POA table size by removing some records.
It's taking space
The records count almost 5 million
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 ;)
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
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.
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
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
