Post reply

user SID

  • November 19, 2003 at 3:51 pm

    #84744

    This is going to be a strange question. When you create a user account a SID is created in the sysxlogins table. If you delete that user, will that SID ever be used again?

    Example. you add user "bob" (SQL Logon). you delete "bob". Will the SID that was associated with "bob" EVER be used again?

    Thanks in advance,

  • November 19, 2003 at 6:25 pm

    #482776

    If you let the system generate the SID, it will be a GUID (as it is generated by NEWID()), so system-generated SIDs should never be the same. On the other hand, you can override this behavior by choosing the SID when you run sp_addlogin, which would permit the re-use of a SID (that's to allow you to move logins from one server to another).

    --Jonathan



    --Jonathan

  • November 20, 2003 at 7:14 am

    #482852

    Thanks for the help. You just gave me the answer I was needing.

    Take care,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply