Can I customize an ACL for certain records in a table?

[simran3]

Hi,

I have a request to give a certain group of users access to only certain records in a table. These records do have a field with a certain value which I can easily filter out, but am I able to apply that to an access control and make it available for just one role?

[Mayur2109]

Hi @simran3 ,

Is it a core table, extended table or custom table ..can you please specify.

Regards,

Mayur Shardul

[simran3]

It is the pm_project table

[Mayur2109]

Hi @simran3 ,

For OOTB tables you should not changes existing ACL's as it is recommended.

You can create new ACL and give the conditions of role, filter.

Please check and Mark Helpful and Correct if it really helps you.

Regards,
Mayur Shardul

[Aman Kumar S]

Hi @simran3 

If that's the case use combination of Query BR and ACL.

If you only use ACL, it will be bad from UI perspective, so Query BR will handle the filtering of the records and ACL can take care of the security.