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
1 ACCEPTED SOLUTION
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! 🙏
