delete the fake or unwanted the custom service role from Aria Automation Identity and Access Management.

Products

• VMware Aria Suite

Issue/Introduction

if user Injected the new service roles by mistake or wanted to remove service role(highlighted in screenshot) from Aria Automation Identity and Access Management. 

Environment

Aria Automation 8.x

Resolution

1.  Take snapshot of VRA appliance and back up of identity-db ( vracli db dump identity-db >> identity-db-dump.sql )
   
   
2. Login into identity-db : vracli dev psql identity-db

3. \x to extend display 
   
   
4. run the select query on identity-db to identify the service role id
   
   select * from identity_service_role;
Example custom Service role id = "a8f2a997-ac0e-4509-98e9-1fed74141e3a"
   
   
5. delete the customer service role from Identity-db using the id from previous select query: 
   
   delete from identity_user_service_role where role_id = 'a8f2a997-ac0e-4509-98e9-1fed74141e3a';
delete from identity_group_service_role where role_id = 'a8f2a997-ac0e-4509-98e9-1fed74141e3a';
delete from identity_service_role where id = 'a8f2a997-ac0e-4509-98e9-1fed74141e3a';
   
   
   
6. After deleting the unwanted service role from identity-db, custom service is removed on UI.