User Table

sandeep6
Tera Contributor

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

1 ACCEPTED SOLUTION

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

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

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