how to delete bulk entitlements from Role

[gagan94]

Hey,

Is there any way to delete/Inactive entitlements in a bulk from roles  or is there any custom query that can help to resolve the concern. I checked manually one by one I can disable but what should I do if I am having bulk of entitlements.

Thanks and Regrards,

Gagan Juneja

[sahajranajee]

@gagan94 ,

Do you wish to remove entitlements from role? or inactive the entitlements from the endpoints?

[rushikeshvartak · Accepted solution]

@gagan94 

Role inactive : 

update roles set status=0 where rolename in ('A', 'B') limit 2;

Always use limit & update accordingly

A & B are role name 

You can also inactive based on endpointkey column

update roles set status=0 where endpointkey in (select endpointkey from endpoints where endpointname = 'AD') limit 2;

Removal of entitlement : this you can do via import sheet keeping all entitlement you need & if you need no entitlement inside role you can keep any random name in entitlement value & Existing role entitlement tick option when you click on upload role association. 

Link for import sheet format 

https://saviynt.freshdesk.com/support/solutions/articles/43000618941-uploading-role-associations