syncing model_has_permissions with roles + permissions

[aa384]

if I remove a permission from the role, the entry still exists in model_has_permissions. Is there a way that these can all be synced or will I have to do it manually?

example - user 1 has role 1 with permission 1, I remove permission 1 from role 1 but user 1 is still left with permission 1

[erikn69]

if I remove a permission from the role, the entry still exists in model_has_permissions.

role permision is handled by role_has_permissions, if you remove a permission from the role, the data on that table get deleted, not on model_has_permissions

laravel-permission/config/permission.php

Line 71 in fc841f8

'role_has_permissions' => 'role_has_permissions',

Maybe, after deleted you forget $this->forgetCachedPermissions(); for cache refresh

[aa384]

so model_has_permissions is never called and I dont need to worry about the entries in there you are saying?

[erikn69]

Yes, it is never called on your example, but it is a good idea adding forgetCachedPermissions after role or permission delete

[erikn69]

No, i don't misunderstood your question. You misunderstood how package works,

if I have role number 1 with permission number 1 and 2. if I give user 1 , role 1. the model_has_permissions table will save an entry for user 1 with both permission number 1 and 2

I repeat again, when you assign a role number 1 to a user 1, there is not a entrie on model_has_permissions, it adds a entrie on model_has_roles, when you assign to role number 1 the permission number 1 and 2, there is two entries o role_has_permissions, model_has_permissions is never used on this example

laravel-permission/config/permission.php

Lines 55 to 71 in dbc6c18

	'model_has_permissions' => 'model_has_permissions',
	/*
	* When using the "HasRoles" trait from this package, we need to know which
	* table should be used to retrieve your models roles. We have chosen a
	* basic default value but you may easily change it to any table you like.
	*/
	'model_has_roles' => 'model_has_roles',
	/*
	* When using the "HasRoles" trait from this package, we need to know which
	* table should be used to retrieve your roles permissions. We have chosen a
	* basic default value but you may easily change it to any table you like.
	*/
	'role_has_permissions' => 'role_has_permissions',

$role1->givePermissionTo(['permission1', 'permission2']); // add two entries on role_has_permissions
$user1->assignRole($role1); // add one entrie on model_has_roles
$role1->delete(); // remove 1 entrie on model_has_roles, and 2 entries on role_has_permissions
// model_has_permissions was never used

[aa384]

thank you @erikn69. I think I have explained my self poorly here, but I appreciate you taking the time to respond.

[erikn69]

Maybe you are want to delete permissions insted of roles, if you delete permission 1, it removes model_has permissions and role_has_permissions entries

[aa384]

[angeljqv]

Seriously, did you mark yourself as answerer without any answer, that is why people stop helping

[aa384]

@angeljqv I have updated my answer with more detail