Unexpected behavior when trying to connect to a database. Facts:
1) The privilege to connect to the database was revoked from public.
2) User without superuser privileges uses a role with superuser rights (usage confirmed with SHOW current_role.)
3) Unecpected Message: FATAL: permission denied for database "db" DETAIL: User does not have CONNECT privilege.
After granting one of the listed privileges it is working as expected.
1) granting superuser to user
2) granting connect to db for user
3) granting connect to db to group
3) granting connect to db to public
What am I missing? --Michael