Query Range ACL issue

[rachelconstanti]

Good morning,

I have a group of users receiving this error

Part of the query on sc_req_item has been ignored because of insufficient access for 'query_range' operation on sc_req_item.cat_item.sc_catalogs

How do I create an ACL on .cat_item.sc_catalogs?  

This is not an option within the ACL

Here are the current query range ACLs for that table:

Thank you,

Rachel

[Tanushree Maiti]

Hi Rachel,

This just for your reference. 

[Tanushree Maiti]

Give Name ,Description,Role as per your requirement.

[rachelconstanti]

That is how that ACL is setup in the instance.

[Ankur Bawiskar · Accepted solution]

@rachelconstanti 

you are dot walking 2 levels so you will require extra query_range ACL

-> create query_range ACL on RITM.Cat Item and give snc_internal role

-> create query_range ACL on Item.Catalogs and give snc_internal role

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