> CREATE TABLE orders ( id int, product text, number int, employee text ); > ALTER TABLE orders ENABLE ROW LEVEL SECURITY; > CREATE POLICY p1 ON orders FOR ALL TO PUBLIC USING (employee = current_user); > GRANT ALL ON TABLE orders TO PUBLIC; > SET SESSION AUTHORIZATION m1; > INSERT INTO orders VALUES (1, 'Screw', 10, 'm1'); > INSERT INTO orders VALUES (2, 'Nail', 5, 'm2'); -- > SET SESSION AUTHORIZATION m2; > INSERT INTO orders VALUES (3, 'Hammer', 1, current_user); > SET SESSION AUTHORIZATION m1; > SELECT * FROM orders; [...] > SET SESSION AUTHORIZATION postgres; > SELECT * FROM orders; [...]