Do we need `users.permissions`?

[kenjis]

shield/src/Database/Migrations/2020-12-28-223112_create_auth_tables.php

Line 18 in 5d7ec18

'permissions' => ['type' => 'text', 'null' => true],

[lonnieezell]

Yes. That holds the user-specific permissions instead of permissions held at the group level.

[kenjis]

It seems we do not use the column.
There is the auth_groups_users table.

[MGatner]

I think @kenjis meant auth_permissions_users - we are storing them in a separate table so the field on users isn't needed:

https://github.com/codeigniter4/shield/blob/develop/src/Authorization/Traits/Authorizable.php#L312-L315

[kenjis]

Yes, auth_permissions_users.
Remove users.permissions?

[lonnieezell]

Ah, yes, that was an old way I was trying, thinking I was "optimizing", but ended up decided just to do it right lol. It can be removed.

[MGatner]

Remove!