The perm entry in the permission table is one of the last dark age places where we need to do LIKE queries to get the value.
This mode of storage makes it potentially break for permissions that are named similar to other permissions.
I think we could then (in order to reduce the number of SQL queries) cache the permissions for each role in the variable table.

Opinions?

Comments

drumm’s picture

drumm
he/him
Location NY, US
commented

+1
normalization++
etc.

jhriggs’s picture

jhriggs commented

See similar (but not duplicate) 12596 which is based on discussion in 12542.

coreb’s picture

coreb commented
Version: x.y.z » 6.x-dev

Moving out of the x.y.z queue into 6.x-dev. I have no idea if this is still viable or not anymore.

webchick’s picture

webchick
she/they
Primary language English
Location Vancouver 🇨🇦
commented

Yep, still an issue in 5.x/6.x.

Paul Natsuo Kishimoto’s picture

Paul Natsuo Kishimoto commented

Subscribing.

kkaefer’s picture

kkaefer commented
Status: Active » Closed (duplicate)

See http://drupal.org/node/73874.