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

dmathur09
Kilo Sage
Kilo Sage

Hi Bandi,

This is an OOB behavior, multiple groups can provide you with the same role. I would not suggest you to write BR and customize the OOB functionality. There is no harm in user having same role given multiple time. There will be no impact on the license.

Regards,

Deepankar Mathur 

bandi
Tera Contributor

Hi Deepankar Mathur,

there is no use to allowing to add again again this type of behavior how to stop. business rule not able to write for this ? 

 

Thanks & Regards,

Bandi.

 

bandi
Tera Contributor

Hi Deepankar,

 

My problem is User id AB123 - Admin (Role) added and allowing multiple times from Same groups , Here Role also duplicate and group also duplicates. 

For example : cmdb_read  role added multiple times from A group and B group , repeatedly 

for more details plz find the attachment

 

Think this is not OOB , Please help me for solution.

Regards,

Bandi

Hi Bandi,

I am able to replicate the issue in my instance. Seems like to be an OOB bug.

I would request to you to reach out to HI team and create a problem ticket.

Regards,

Deepankar Mathur