Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
faizankh
Starting Member
8 Posts |
 Posted - 2006-10-30 : 16:23:04
|
| Could you please help me with this scenario. I think the right way is to use the SP_Change_User_Login store proc, but i'm not sure. Please help.• ServerA is identical to ServerB in hardware & software• Both servers have a DB called MorganDB• The SQL user Morgan has access to the MorganDB on both servers• The Windows Authenticated user Roseanne has access to the MorganDB on both servers• A backup is made of the MorganDB on ServerA and is verified• The backup is successfully restored to ServerB• Morgan no longer has access to MorganDB on ServerB, but Roseanne does.How is this resolved and why? |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-10-31 : 07:09:11
|
| Yup, sp_change_user_login 'update_one', 'Morgan', 'Morgan'Jay White |
 |
|
|
|
|
|
SQL login Help