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 |
|
kneekill
Yak Posting Veteran
76 Posts |
 Posted - 2011-12-21 : 04:24:36
|
| Hi All,Is there any way i can backup all the database users (Database -> Security - Users) in a script ?OR move the database users from one database to anther database within the same server?I am asking this because we have 2 instances of same database with different names under the same server and i will have to manage user security differently between them (and there are many users).Thank you |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-21 : 05:29:03
|
| Create specific roles in those two databases and assign the users to those roles.PBUH |
 |
|
|
kneekill
Yak Posting Veteran
76 Posts |
Posted - 2011-12-21 : 08:57:17
|
Hi SachinThe problem is not with assigning roles to the users. I am trying to back up the users in one database so that i can create the same users in second database.Please let me know if i am not clearquote:
Originally posted by Sachin.Nand
Create specific roles in those two databases and assign the users to those roles.PBUH
|
|
|
|
Sachin.Nand
2937 Posts |
|
|
|
|
|
Database Users backup