mapping login to db user. ALTER LOGIN, or ALTER USER

Question

mapping login to db user. ALTER LOGIN, or ALTER USER

winston Smith

SSCoach

Points: 19500
More actions
January 9, 2010 at 8:10 am

#229012

Im reading a book an one step in one of the tutorials is to "Use ALTER LOGIN for every SQL Server login to ensure correct mapping to a user in the secondry database".
I can map a user to a login using:
ALTER USER user1
WITH LOGIN login1.
I cannot find a way to do this using ALTER LOGIN. is this a typo, or am i missing something?

Viewing 5 posts - 1 through 4 (of 4 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

looks to be a typo. It could be referring to a credential - but still as typed it would be a typo.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

ALTER LOGIN (http://msdn.microsoft.com/en-us/library/ms189828%28SQL.90%29.aspx) doesn't map to users. the ALTER USER (http://msdn.microsoft.com/en-us/library/ms176060%28SQL.90%29.aspx) is what you use to connect the login to the user.

winston Smith SSCoach Points: 19500 More actions · Answer 3

Thanks folks. This is one of the MS Press training books for 70-432 exam. i have found numerous inaccuracies and mistakes in this book. one more for the list.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

You're welcome.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events