insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'auth.user.twoFactor' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'auth.user.verifyTwoFactor' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';

insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'auth.user.twoFactor' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'auth.user.verifyTwoFactor' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';

insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'auth.user.twoFactor' as resourceID from smd__organization_role WHERE roleID LIKE '%.creator.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'auth.user.verifyTwoFactor' as resourceID from smd__organization_role WHERE roleID LIKE '%.creator.%';


DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.approver.%' and resourceID = 'organization.role.create';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.approver.%' and resourceID = 'organization.role.groupDelete';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.approver.%' and resourceID = 'organization.role.groupModify';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.approver.%' and resourceID = 'organization.role.list';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.approver.%' and resourceID = 'organization.role.remove';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.approver.%' and resourceID = 'organization.role.update';

DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.editor.%' and resourceID = 'organization.role.create';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.editor.%' and resourceID = 'organization.role.groupDelete';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.editor.%' and resourceID = 'organization.role.groupModify';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.editor.%' and resourceID = 'organization.role.list';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.editor.%' and resourceID = 'organization.role.remove';
DELETE FROM smd__organization_role_has_resources WHERE roleID LIKE '%.editor.%' and resourceID = 'organization.role.update';