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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-11 : 07:11:12
|
| Mala writes "Hi ,How can i fix Broken Logins for users when I restore/attach a database. For the users who doesn't own objects I can execute sp_revokedbaccess and set default and grantdbaccess. If ouser owns objects then it won't allow me to revokeaccess.Thanks in advance.Mala" |
|
|
Argyle
Yak Posting Veteran
53 Posts |
Posted - 2003-02-11 : 12:08:39
|
| Take a look at sp_change_users_login/Argyle |
 |
|
|
|
|
|
Broken Logins