How to link a login to a database user

USER1 is the db_owner of the database INVENTORY. There exists an identical
SQL Server login name USER1. When I double-click on the login name, in the
Database Access page, I find that USER1 is permitted to access INVENTORY.
However, there is no linkage between the login USER1 and database owner
USER1. The "User" cell at the right of the INVENTORY database is blank in
the Database Access page. However when I try to enter USER1 into the cell, I
get an error message telling me the user USER1 already exists in INVENTORY.
However can I link the login name to the database user name?
TIA
KMTake a look at sp_change_users_login in BooksOnLine.
Andrew J. Kelly SQL MVP
"Krygim" <krygim@.hotmail.com> wrote in message
news:uT89uyOOEHA.4036@.TK2MSFTNGP12.phx.gbl...
> USER1 is the db_owner of the database INVENTORY. There exists an identical
> SQL Server login name USER1. When I double-click on the login name, in the
> Database Access page, I find that USER1 is permitted to access INVENTORY.
> However, there is no linkage between the login USER1 and database owner
> USER1. The "User" cell at the right of the INVENTORY database is blank in
> the Database Access page. However when I try to enter USER1 into the cell,
I
> get an error message telling me the user USER1 already exists in
INVENTORY.
> However can I link the login name to the database user name?
> TIA
> KM
>|||Hi,
Did you restore the database Inventory recently. This would have caused the
link break between syslogins table in master and
sysusers table in Inventory database. The link can be brought again by
executing the below statements in query analyzer:-
USE Inventory
go
sp_change_users_login 'Update_One', 'user1', 'user1'
Tahnks
Hari
MCDBA
"Krygim" <krygim@.hotmail.com> wrote in message
news:uT89uyOOEHA.4036@.TK2MSFTNGP12.phx.gbl...
> USER1 is the db_owner of the database INVENTORY. There exists an identical
> SQL Server login name USER1. When I double-click on the login name, in the
> Database Access page, I find that USER1 is permitted to access INVENTORY.
> However, there is no linkage between the login USER1 and database owner
> USER1. The "User" cell at the right of the INVENTORY database is blank in
> the Database Access page. However when I try to enter USER1 into the cell,
I
> get an error message telling me the user USER1 already exists in
INVENTORY.
> However can I link the login name to the database user name?
> TIA
> KM
>|||Exactly! I have just restored the database.
Thank you and Andrew for the solution.
KM
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:elJZo8OOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Did you restore the database Inventory recently. This would have caused
the
> link break between syslogins table in master and
> sysusers table in Inventory database. The link can be brought again by
> executing the below statements in query analyzer:-
> USE Inventory
> go
> sp_change_users_login 'Update_One', 'user1', 'user1'
> Tahnks
> Hari
> MCDBA
>
> "Krygim" <krygim@.hotmail.com> wrote in message
> news:uT89uyOOEHA.4036@.TK2MSFTNGP12.phx.gbl...
identical[vbcol=seagreen]
the[vbcol=seagreen]
INVENTORY.[vbcol=seagreen]
in[vbcol=seagreen]
cell,[vbcol=seagreen]
> I
> INVENTORY.
>