Microsoft Dynamics CRM (Archived)

What is POA(PrincipalObjectAccess) table?

(0) Share

Report

Posted on by Akanksha Ranjan

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

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

Kishor Kumar 3,710 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mandar Joshi 2,116 on at

Like (1)

Report

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/.../

Was this reply helpful? Yes No
Akanksha Ranjan 460 on at

Like (0)

Report

Hi Prashant,

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

Was this reply helpful? Yes No
Verified answer

PS 23,577 on at

Like (0)

Report

Hi Akansha

Read this blog for access team and POA relations

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

Was this reply helpful? Yes No
Verified answer

Mridula 275 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Akanksha Ranjan 460 on at

Like (0)

Report

Thank You Mridula :)

Was this reply helpful? Yes No