Restrictive RLS policy

I was (in hopes of having cleaner RLS policies) thinking of using a restrictive RLS policy. I have read that these function sorta like an "AND". So you could have a series of "ORs" and than an "AND" like "is not banned".

Has anyone tried something like this?

CREATE POLICY block_banned ON account_organization_join_public
  AS RESTRICTIVE
  FOR SELECT
  USING (
    banned IS NOT TRUE
  );

CREATE POLICY block_banned ON account_organization_join_public
  AS RESTRICTIVE
  FOR SELECT
  USING (
    banned IS NOT TRUE
  );

CREATE POLICY block_banned ON account_organization_join_public
  AS RESTRICTIVE
  FOR SELECT
  USING (
    banned IS NOT TRUE
  );

CREATE POLICY block_banned ON account_organization_join_public
  AS RESTRICTIVE
  FOR SELECT
  USING (
    banned IS NOT TRUE
  );

Restrictive RLS policy

Similar Threads

Similar Threads

Similar Threads