- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2025 09:35 PM
Hi Guys,
I was wondering is it a good idea to change the Unique flag on a sys_user table from user id to email.
Has anybody done that?
I have come across a Scenario where there are 2 users with the same user ID. Hence first has created a record in the sys_user table but second will not.
Cheers
Sandeep
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2025 10:02 PM
Hi @sandeep6 ,
When both user ID will go for login will it create a issue is that what you meant in your reply?
Yes, it should always be unique( as user are using user id and password ) majorly for authentication
if you want to make email address unique (let's say you want all the user in your system to have unique email address) you can go to email field and check unique checkbox.
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2025 10:21 PM
Hi @sandeep6
This is more of a governance issue, and I would also categorize it as a data issue. No two users should ever share the same user ID — that’s a fundamental rule. Additionally, making manual changes to flags is not recommended, as it can have serious negative impacts and is not considered a best practice.
It would be better to establish proper data governance and restrict user record creation (especially those not coming through integration) to a limited set of authorized users.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************