Principal user (Id=guid, type=8, roleCount=3, privilegeCount=217, accessMode='0 Read-Write', AADObjectId='guid', MetadataCachePrivilegesCount=4989, businessUnitId=guid),
is missing prvAppendTonew_Country privilege (Id=guid) on OTC=10471 for entity 'new_country' (LocalizedName='Country').
Consider adding missed privilege to one of the principal (user/team) roles.
User is member of a Microsoft Team. Canvas App is shared to that Team with Security Role assigned.
Security Role has the following privileges for Table A entity:
And for Country entity:
If I check access to a particular Country I see the following:
Diagnostics for this user shows:
If this is the reason for this issue, how can I avoid it? My canvas app users are Team members and inherit their role from that Team and none of them has a security role directly (manually) assigned to them.