How to update assignment in auth_assignment table in Yii2 Rbac?

Question

I am using RBAC in my yii2 basic application to assign module to users based on their roles.

I store role id and user_id in auth_assignment table.

Now if i change role of user during update. I have to change it also in auth_assignment table. Now I want to delete all entries of that user from auth assignment and add new entries in table.

The problem is that i cannot find any RBAC function to update auth_assignment table data or to delete auth assignment table data.

There is a function in Yii2 Documentation removeAllAssignments() but it truncates the whole table i only want to delete entries for perticular user.

Is there any function available for that?

Bizley · Accepted Answer · 2016-09-28T10:29:48.380

1

Yes, there is.

assign() assigns role to a user.
revoke() revokes role from a user.
revokeAll() revokes all roles from a user.

To get the list of all roles assigned to a user you can use getRolesByUser().

edited Sep 28 '16 at 10:29

answered Sep 28 '16 at 10:04

Bizley

17,392
5
49
59

Thanks Bizley revokeAll() method helped me. – Ninja Turtle Sep 28 '16 at 10:11
Right, I will add this as well to answer for others. – Bizley Sep 28 '16 at 10:28

score 0 · Answer 2 · answered Sep 28 '21 at 11:37

Assume the role name is being sent from the form and you are storing the value in the 'role' field, then add this to your model.

This will remove the existing assigments, and assign the new ones.

public function afterSave($isInsert, $changedOldAttributes)
{

    // Update the user role in the RBAC layer
    // Purge the user tokens when the password is changed
    if (array_key_exists('role', $changedOldAttributes)) {

        $auth = Yii::$app->authManager;

        $auth->revokeAll($this->id );

        $role = $auth->getRole($this->role);

        $auth->assign($role, $this->id);
    }
        return parent::afterSave($isInsert, $changedOldAttributes);
    }

How to update assignment in auth_assignment table in Yii2 Rbac?

2 Answers2