Hello,
I'm facing this "Cannot create a record in Service orders (SMAServiceOrderTable). Security policy permission denied."
the case that I need to restrict both projects and services to specific value from project group Id, at first I created a new role with a new duty and a new privilege, then a query that has just the projTable and I put on a range on the value I need, the I created a policy that uses this query and it works on the new role I created.
it works fine when I open "all projects", and when I open "all service orders" it filters good on the value I want, but when I create a service order I got the mentioned error.
where I went wrong? is it even possible to restrict both with the same role?