Remove readonly role

I have been thinking about the readonly role. There is very little benefit offered by adding this role for the additional surface area introduced.

We already make this simple in Supabase dashboard, so let's remove it from the default database setup.