magento2 – Edit user role permissions in the database?

You have the table authorization_rule and the permissions are in the column resource_id

Find the role_id do you want to modify in the table authorization_role and do

UPDATE `m2_authorization_rule` SET `resource_id`='Magento_Backend::all', `permission` = 'allow' WHERE role_id = 'ROLE_ID_TO_MODIFY';