Duplicate roles being assigned to user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2022 01:40 AM
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
- Labels:
-
Cost Management (ITSM)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2022 02:58 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-11-2022 02:59 AM
Hi Bandi,
You can try writing the BR and let me know in case of any queries.