dbo association
From: Mark (mar.mcgaughey_at_milestonelp.com)
Date: 08/18/03
- Next message: Gary L.: "GRANT - Execute SP"
- Previous message: Gerry: "Changing Security Audit Option"
- Next in thread: Dan Guzman: "Re: dbo association"
- Reply: Dan Guzman: "Re: dbo association"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 18 Aug 2003 09:31:45 -0700
I have restored a data base backup from a different sql
server that has different users "dbo" for instance. How
can I associate "dbo" in the security login with one that
is created in the database table that was restored? Will
it matter? I have tried to use the following procedure but
will not work for any member of the security group.
sp_change_users_login [ @Action = ] 'action'
[ , [ @UserNamePattern = ] 'user' ]
[ , [ @LoginName = ] 'login' ]
auto_fix, Update_one will not work either.
Thank you for your help
- Next message: Gary L.: "GRANT - Execute SP"
- Previous message: Gerry: "Changing Security Audit Option"
- Next in thread: Dan Guzman: "Re: dbo association"
- Reply: Dan Guzman: "Re: dbo association"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
