Remove multiple users roles at once

suru2
Tera Contributor

Hello All,

 

I have one task which I want to perform for users roles related, where more than 1500+ users has some Approval roles and now client don't want that roles for all those 1500+ users should have that, he want to add that roles for only few users, so as it is 1500+ users we can't remove those roles manually so need suggestion on this whether we should use background script or anything else.

Please help on this if anyone gone through same requirement.

 

Thanks,

2 REPLIES 2

Sandeep Rajput
Tera Patron
Tera Patron

@suru2 You can plan to Use Delete Job to delete roles from sys_user_has_role table.

 

Screenshot 2024-06-06 at 9.07.29 PM.png

suru2
Tera Contributor

Hello Sandip,

I don't want to delete the role, I want to remove the roles from those 1500+ users, and after removing those roles I need to provide those roles to only few 50 users.

Thanks,