Changing user associated with a login

• rocky

  SSCrazy

  Points: 2120

  More actions

  January 22, 2007 at 2:17 pm

  #62165

  I have this:

  Login                User

  U12345             U12345

  I want to change the user name U12345 to a meaningful name:

   

  Login                User

  U12345              Sue Howard

   

  How can I do that?  How do others keep track of an actual name associated with a login?

  thanks!

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 22, 2007 at 6:56 pm

  #684833

  check sp_dropuser and sp_adduser commands...

  In 2005 you can do this using ALTER USER command..

  MohammedU
  Microsoft SQL Server MVP