Issue Feature Closed

#14822Group membership defined by MM relation instead of text field.

old_Pic2008 06/16/05, 17:33 updated 10/02/18, 12:39

Description

The usergroup memberships for backend and frontend users is currently defined by a comma separated string stored in a binary data field.
This makes getting users from the DB based on what group they belong to cumbersome and inefficient as it requires using the REGEXP operator (more specifically: SELECT * FROM be_users WHERE usergroup REGEXP ‘(,|^)<group_id>(,|$)’;).<br>Replacing this with a many-to-many relationship in the next major revision of Typo3 would in my eyes be a good thing.</group_id>

(issue imported from #M1203)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.