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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-03-28 : 13:08:22
|
| How do I drop all the users from a database? After I restore a database to my inherited development server, I don't want the database users to appear in user list. I realize the SIDs may no longer be synchronized and this alone should prevent access. However, I want the environment to be 'clean' w/o orphan users. After restores, I do synchronize the SIDs for the developer user accounts.Thanks,Ray PS - Since this is an inherited server, I need a similar solution for the server logins. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-28 : 14:27:20
|
| Take a look at sp_revokedbaccess, sp_dropuser, sp_droplogin, and sp_revokelogin in SQL Server Books Online.Tara |
 |
|
|
|
|
|
drop users for development database