Duplicate roles being assigned to user

bandi
Tera Contributor

Hi Team, 

User Id is have  Role and Groups but it is multiple duplicate roles or added from same groups, suppose user edit the role and try to add again its allowing to add existing role .. how to solve this type of problems in sys_user table. 

for this how to write  a BR on sys_user_has_role table before insert check if there is any user has the role if yes ignore or else create it.

for example fined the screenshots

Need help Thank you in Advance

6 REPLIES 6

bandi
Tera Contributor

write a BR on sys_user_has_role table before insert check if there is any user has the role if yes ignore or else create it, 

we will try this and let me know.

Hi Bandi,

You can try writing the BR and let me know in case of any queries.