ACL for Table Restriction when user is given a specific role, How?

[symonflores_23]

We wanted to restrict a user with a specific role from accessing a table if they don't have any pending ticket assigned to them or their assignment group.

Context: External users will have a role called "restricted_itil" where they will have access to incident table, RITM, Change Request "IF and ONLY IF" they have tickets assigned to them or to their assignment group. So if they don't have any pending incident tickets assigned to their assignment group, then they can't access the incident table.

How do we start creating this in ACL?

[AJ-TechTrek · Accepted solution]

Hi @symonflores_23 ,

This is not possible using the ACL in my knowledge as ACL will provide your provide the access, read, Write and Modify to specific table based in the Roles.

You wan to achieve using this through Business Rule or Client script.

@Dr Atul G- LNG Any thoughts on that.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[Dr Atul G- LNG]

Hi @symonflores_23 

I am agree with @AJ-TechTrek . ACL is used to provide access not to restrict. You can achieve this Query BR. 

[symonflores_23]

Will try BR Query. Thanks for the insight @AJ-TechTrek and @Dr Atul G- LNG .