Forum Discussion

Komondor5's avatar
Komondor5
Copper Contributor
Nov 07, 2024

GUID reuse deleted accounts

I had a meeting today and they talked about using the user GUID to identify users, the question came up if a user account is deleted for say 6 months and then I create an account with the same name and organization as well as username will the GUID be the same.  I found information on how the GUID is built that says yes but it just seems like the answer should be no.  An account that is recreated will not get the same GUID since they are somewhat randomly generated.

This is a Server 2016/19  Win10 environment with no Internet connectivity and no Office 365 or teams.

Does anyone have a link to how Windows generates a user GUID  it seems that SQL server uses  that and if in account is deleted and recreated they will not have access to the old data?

 

This is all new to me as my thought is why would you not use usernames, and for me you assign permissions in Windows using groups. 

 

Not an SQL expert so any help would be appreciated.

 

Resources