Remove duplicate records from Group Member[sys_user_grmember] table.

[HrishabhKumar]

How can we remove duplicates from Group Member table. I know we can use Fix scripts to do that, but I want to know the optimal approach.

[HrishabhKumar]

no I'm saying there are 3 records where (group=tech resource & user=admin HK), There should only be one record.

[Ankur Bawiskar]

@HrishabhKumar 

did you check which script is inserting that?

ideally it should not be allowed?

[Prasad Pagar]

Hi @HrishabhKumar 

Did you tried understanding how duplicate got added at first place? I think fixing or removing it from this may having cascading impact if they are referred anywhere.

1. Get your original source fixed which is adding duplicate

2. Find out what cascade impact removal will have

3. Fix existing duplicate records