Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

What is POA(PrincipalObjectAccess) table?

Posted on by 460

Hi Experts,

I want to know what is POA table and how data gets created in the table ?

I have tried to search about this but got only the possible ways to minimize the growth of POA table.


Please Help

Thank You!

*This post is locked for comments

  • Akanksha Ranjan Profile Picture
    Akanksha Ranjan 460 on at
    RE: What is POA(PrincipalObjectAccess) table?

    Thank You Mridula :)

  • Verified answer
    Mridula Profile Picture
    Mridula 275 on at
    RE: What is POA(PrincipalObjectAccess) table?

    Hi Akanksha,

    When a record is shared to individual users, say, an account record is shared to 10 users, so, it will create 10 entries in POA table, whereas, if a record is shared to access team, then there will be only one entry created for team in POA table.

    Please correct me if I am wrong.

    Thanks,

    Mridula

  • Verified answer
    PS Profile Picture
    PS 23,577 on at
    RE: What is POA(PrincipalObjectAccess) table?

    Hi Akansha

    Read this blog for access team and POA relations

    crmbusiness.wordpress.com/.../crm-2015-the-benefits-of-access-teams

  • Akanksha Ranjan Profile Picture
    Akanksha Ranjan 460 on at
    RE: What is POA(PrincipalObjectAccess) table?

    Hi Prashant,

    I want to know how it will behave for Access team ?

  • Suggested answer
    Mandar Joshi Profile Picture
    Mandar Joshi 2,116 on at
    RE: What is POA(PrincipalObjectAccess) table?

    POA table stores information about sharing of records in CRM. Every time shares are granted on records in CRM, a new entry is created in POA table. It stores information of User/Team with the record is stored, Object GUID, rights granted, etc.

    You can also check below blog for information on POA.

    us.hitachi-solutions.com/.../

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: What is POA(PrincipalObjectAccess) table?

    Hi Akansha,

    it is a table which stores information of shared records

    This URL might help:

    030bacf.netsolhost.com/WordPress

    Retrieve POA

    community.dynamics.com/.../principal-object-access-table-poa-table-grows-large

    And obviously you have links to control the performance but still providing:

    support.microsoft.com/.../2664150

  • Suggested answer
    Kishor Kumar Profile Picture
    Kishor Kumar 3,702 on at
    RE: What is POA(PrincipalObjectAccess) table?

    Hi Akanksha,

    POA(PrincipalObjectAccess) table the data is created when you share/assign the records between the users in CRM

    When the performance of CRM gets slow you have to check the POA about the count of

    records

    Check this link below,

    030bacf.netsolhost.com/WordPress

    Hope it helps you

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans