Row Level Security: Schema

schema.sql

create role application_user;
grant all on all tables in schema public
to application_user;

create table users (
  name text not null primary key,
  role text unique not null
);

create table data (
  id uuid default gen_random_uuid() not null primary key,
  value text,
  created_at timestamp with time zone default now()
);

create table user_data (
  data_id uuid references data(id),
  user_role text
);