From the source
Supabase published a tutorial explaining how Postgres roles, privileges, and permissions work, covering basic concepts like database objects, privileges, roles, and ownership, and demonstrating how to create users, grant permissions, and debug access errors using the psql command line tool.





