CRM principalobjectaccess (POA)

Principalobjectaccess (POA) table is a important table which holds all grants share on CRM objects. This is just for understanding purpose.

SELECT TOP  - [Principalobjectaccessid] ,[Principalid] ,[Principaltypecode] ,[ObjectId] ,[Objecttypecode] ,[Accessrightsmask] ,[Inheritedaccessrightsmask] from [principalobjectaccess]  with(NOLOCK)

Principalobjectaccessid , Haven GUID of share record.
principalid , Haven GUID of the User or Team receiving the Share.
Principaltypecode –indicates Whether it ' s a User or Team. --user
ObjectId , Haven GUID of the specific object being shared.
Objecttypecode , Haven object type of the record being gkfx.
accessrightsmask –this Field stores the rights granted directly via the ' Sharing ' dialog.
Inheritedaccessrightsmask , Haven rights applied by the system through cascading or reassignment processes is St ORed in this field.

Check Microsoft Query to control this table data:

CRM principalobjectaccess (POA)