Click HERE to see how Saviynt Intelligence is transforming the industry. |
12/05/2023 02:20 AM
Hi,
I am looking for methods to bulk delete the enterprise roles (via file upload) which are no more needed (roles created in dev or test environment, etc)
I have checked the options available in role upload via UI, could not find anything to delete the role as such, there are options for removing entitlements or child roles. Using the role delete button is an option, but I have got some 1000+ roles which are unwanted now. Other option I see is to write a custom query and update name, displayname and status of role which I do not prefer to use.
Apprecaite any inputs in this matter.
Thanks.
12/05/2023 03:55 AM
@Srikanth Upload Role Via Role Management optio,.While importing, you can create a new security system, endpoint, business process, child role, parent role, entitlement type, entitlement value, role owner, and role users. You can also delete existing parent-child roles, role entitlement, role business process, role owner, and role users if it exists.
12/05/2023 05:59 AM
Hi Manu,
but there is no option to delete the role (we do not have any child roles) itself either via upload role via role management or upload role associations.
12/08/2023 04:36 AM - edited 12/08/2023 06:24 AM
Hi @Srikanth
Right now there is no way to Bulk delete of roles, only via csv file is to make the status inactive of the roles you want to soft delete.
Or you can use the custom query job to make the status as inactive and append the name to delete using the role key
ex: SELECT R.ROLEKEY AS ROLES__PRIMARYKEY, CONCAT(R.ROLE_NAME,'-DELETED') AS ROLES__ROLE_NAME,'0' as ROLES__STATUS FROM ROLES R WHERE R.rolekey='1'
Thanks
Darshan
12/08/2023 07:39 AM
@Srikanth As i mentioned there is no way to bulk delete a role and only option is delete existing parent-child roles.
The only option is inactivate them
12/08/2023 01:57 PM
Since this is admin activities this are available options