If you need to change the privileges of the users to whom the role has been granted,you simply change the role's privileges,and the user accounts automatically reflect the privilege change.

Question

Quizplus · Accepted Answer

When a role's privileges are changed, any user accounts that have been granted that role will automatically reflect the privilege change. This is one of the benefits of using roles in database security management.

If You Need to Change the Privileges of the Users