Currently, text formats - roles relationships are stored as a comma-separated string of roles references. This is bad since you can't use joins, nor index, etc...

There is a filter DB revamp proposal: #258939: Filter system revamp, this issue may be a follow up of that one.

Comments

dropcube’s picture

Title: Add format_role table to store text format - role relationship » Add format_role table to store text format - role relationships
Issue tags: +FilterSystemRevamp
sun’s picture

Status: Active » Closed (duplicate)

Marking as duplicate of #11218: Allow default text formats per role, and integrate text format permissions. Please search for existing issues before submitting a new one. You can follow up on that issue to track its status instead. If any information from this issue is missing in the other issue, please make sure you provide it over there.

However, thanks for taking the time to report this issue.