User ID's created with email @example.com in User table, can we delete?

[Prabhu6]

I'm curious how the User ID's are created in the sys_user table; now, while doing some plugin installation, roles have been added to those IDs ( email- @ example.com); can we delete those User ID's?

[Dr Atul - LNG · Accepted solution]

What does SN local user mean? Are they Service Account?

Do one thing mate, open the table sys_user_has_role and fill user with the role you want to delete from their profile.

[Dr Atul - LNG]

Hi @Prabhu6 

If those id's are not in use then better to delete else, or remove the role from the groups ( where it has been added).

You can search in user table like emails end with @example.com

[Prabhu6]

Thank you for your swift response; how would those be added to the table? any idea please

[Dr Atul - LNG]

Do u have AD/ Azure integration on place? or any one load any data. 

[Prabhu6]

All those IDs are SN local user accounts.