> My question is why the user should supply the role to the database.
> Doesn't the database know which role every user belongs to.

A role <> a Group.

It is the permissions you wish to have for your connection, which may
be lower than the permissions you could in theory have if connecting
under another role.

Obviously you can only connect as a role that you have been assigned.

Adam