Is there any way to inactive enterprise roles in bulk way

[gagan94]

Hi Team,

I tried to make one role from inactive to active but it is not allowing me to made it active again and we are having approx 100 plus roles which needs to be active from inactive in bulk process.

Thanks and Regards,

Gagan

[rushikeshvartak · Accepted solution]

update roles set status =0 where roletype=4 and role_name in ('A','B')

[gagan94]

Hey @rushikeshvartak  Thanks for your query but requirement is like we are having some entitlements that are tied with one of the entitlement type in particular endpoint, by mistake it was get inactive now we want them to change to active without impacting any role_owner information. We have to be sure that not any role owner information not get impacted.

Conclusion: Is there any solution to change entitlements from inactive to active again in bulk way but without impacting/overwritten role owner information

[rushikeshvartak · Accepted solution]

Use Entitlement Import Sheet

[sahajranajee]

@gagan94 Have you tried role upload from roles page? You should be able to update the rolestatus column as part of update.