Few Users Able to access Child tables but unable to view records of parent table

[DileepK37365987]

Hi All,
I have a bug that occurred recently  . Users able to access Cases tables without any issue but recently few internal users  unable to view  parent table records but having no issue with child table Record . Attached the screenshot .
If any one have ever faced this type of issue Kindly help me with resolving this .

Thanks a million in Advance

Many Thanks

[Tejas Adhalrao]

Hi @DileepK37365987 

This issue usually occurs when users have read access to a child table but are missing read permission on the parent table. ACLs do not always inherit automatically, so a missing or recently changed parent table ACL can block access to parent records while child records still work. Enabling Security Debug and checking parent table ACLs helps identify the exact cause.

[Ankur Bawiskar]

@DileepK37365987 

parent table is Case. What's the child table?

You are saying users are able to access Case table (parent) but few users are unable to view.

Seems to be access issue.

Did you check any CSM Query rule is restricting the data on parent? Is this newly created?

CSM Query Rules 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Validate your ACL written on parent table against the role of those internal user.

It seems ACL is restricting them to view the records.

[vaishali231]

hey @DileepK37365987 

What I would suggest checking:

1. Any recent Read/List/Query ACL changes on the parent Case table
2. Impersonate one of the impacted users and run Debug Security Rules (this will show exactly which ACL is failing)
3. Also check if any Before Query Business Rule is filtering parent records for certain users/groups
4. Lastly, confirm the impacted users still have the required roles/groups for the parent table

In most cases, Debug Security Rules points directly to the failing ACL and the fix is straightforward.

*************************************************************************************************************
If this response helps, please mark it as Accept as Solution and Helpful.
Doing so helps others in the community and encourages me to keep contributing.

Regards
Vaishali Singh