Matriz de Políticas RLS do MSE

O isolamento no MSE garante que operadores acessem estritamente os dados de sua filial:

Tabela Papel Comando Condição

mse.inventory_sessions

authenticated

SELECT

organization_id = (SELECT auth.current_org_id())

mse.inventory_items

authenticated

INSERT

session_id IN (SELECT id FROM mse.inventory_sessions WHERE status = 'OPEN')

mse.stock_reconciliations

authenticated

SELECT

organization_id = (SELECT auth.current_org_id())