User Table

Go to solution
sandeep6
Tera Contributor

‎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

0 Helpfuls
  • 473 Views
1 ACCEPTED SOLUTION

Go to solution
Chaitanya ILCR
Mega Patron
In response to sandeep6

‎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

 

View solution in original post

5 REPLIES 5

Go to solution
Dr Atul G- LNG
Tera Patron
Tera Patron

‎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]

****************************************************************************************************************