Level Security

Row Level Security

CREATE TABLE test (
  id SERIAL PRIMARY KEY,
  username TEXT DEFAULT current_user,
  message TEXT
);
 
ALTER TABLE test ENABLE ROW LEVEL SECURITY;
 
CREATE POLICY test_policy on test USING (username = current_user);

CREATE ROLE test_user_1;
grant all on test to test_user_1;
 
 
CREATE ROLE test_user_2;
grant all on test to test_user_2;

SET ROLE test_user_1;
INSERT INTO test (message) VALUES ('Test user 1 says hi');
 
SELECT * from test;

SET ROLE test_user_2;
INSERT INTO TABLE test(message) VALUES ('Test User 2 Says Hi');
 
SELECT * from test;
 
SELECT COUNT(*) from test;

set role test_user_1;
 
SELECT * from test;
SELECT COUNT(*) from test;