For instance, say I have the role "category manager" and the role "product manager", but then there are some users which need to have access to both categories and products. Ideally, I would like to be able to say that user X has the permissions from both roles, rather than having to create a third "category and product manager" role.
In the backend, assigning a user to a role is done by a radio button, which seems to imply that a user can only have one role. But, the role management backend allows me to select any users to add to the role, and I don't see anything to say that adding a user to the role will remove the user from their current role.
So, can users be added to more than one role?
If it is not possible through the backend, can I assign users to more than one role via the database? i.e. if I add to the database links connecting a user to more than one row, will it apply all of the permissions, or will it only use one of them?