From IRC, earlier tonight:
[18:51] <freelock_> when copying a database to a new name, users get added successfully but do not gain roles
I think we should keep current behavior but document why this does not happen.
The reason is that if we turn this so that the roles work, they will be tied to both db's. It's unintuitive behavior and needs to be explained, but the alternative leads to unintuitive security issues.