<< Cleaning a DateTime for the time portion/Converting DateTime. | Select/Edit <n> rows and Saving Changes is not permitted. >>

Assign orphan users to a new login

by Allan Svelmøe Hansen January 09, 2009 10:13

If you need to assign an orphan user in MS SQL 2005 - meaning a user without a log in - to a new login, or change the login for a user, simply run the following query:

ALTER USER <userName> WITH login = <loginName>

on the database.
This is a problem which can happen if you for example restore databases to a new server, where you have a user in the database, but no mapped login.

Tags: user, login

SQL

Difference in assignment using SELECT and SETExplaining a difference in the functionality of assignment using SELECT and SETAssign EXECUTE on all Stored ProceduresA little script for assigning EXECUTE on all user made stored procedures in a database for SQL Serve...Linked Servers in SQL Server 2005How to set up Linked Server in SQL Server 2005

Comments

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added

Twitter feed

July 30. 11:04
Hate shopping for clothes, should be more online shops

July 29. 16:53
A competition where I can win an iPhone4 by saying why I love smartphones..... problem is: I love my smartphone because it is not an iPhone

July 28. 13:15
Hate doing taxes. Reminds me how much money goes into something I dislike or disagree with.

July 25. 12:59
So - Tour De France ends today. Despite they all are doped up with drugs - it was quite fun this year. #letour

Follow me on Twitter

EXEC(@sql)

SQL Server and related topics

Assign orphan users to a new login

About:
Allan Svelmøe Hansen

Twitter feed

Recent Posts

Disclaimer

EXEC(@sql)

SQL Server and related topics

Assign orphan users to a new login

About: Allan Svelmøe Hansen

Tag cloud

Twitter feed

Recent Posts

Blogroll

Disclaimer

About:
Allan Svelmøe Hansen