How to copy DB users/permissions to another DB?

Hi,
I would like to copy only database users and their permissions from one
Database A to Database B. Is there a script that would do this or is DTS a
possiblilty. What is the best way.
How to transfer logins and passwords between instances of SQL Server
http://support.microsoft.com/kb/246133
"sdmusicmaker" wrote:

> Hi,
> I would like to copy only database users and their permissions from one
> Database A to Database B. Is there a script that would do this or is DTS a
> possiblilty. What is the best way.
|||It's the same version SQL 2000 on the two machines, but different databases
that have the same names. I need the users on one to be in the other one.
"Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> How to transfer logins and passwords between instances of SQL Server
> http://support.microsoft.com/kb/246133
> "sdmusicmaker" wrote:
|||You will need to edit the output script for the specific users you need to
transfer.
"sdmusicmaker" wrote:
[vbcol=seagreen]
> It's the same version SQL 2000 on the two machines, but different databases
> that have the same names. I need the users on one to be in the other one.
> "Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
|||not sure i know what you mean?
"Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> You will need to edit the output script for the specific users you need to
> transfer.
> "sdmusicmaker" wrote:
|||Here is a reference:
How to Script User and Role Object Permissions in SQL Server
http://www.sql-server-performance.com/bm_object_permission_scripts.asp
"sdmusicmaker" wrote:
[vbcol=seagreen]
> not sure i know what you mean?
> "Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
|||Run the script mentioned in the Microsoft KB. This will generate a result
which is actually a SQL script. Since this will insert all user accounts to
the new instance, you can modify the script so it will only insert the users
you want
MCP MCDBA MCAD MCSD MCT MCTS MCITP:DBA
"Helping people grow and develop their full potential as God has plan for
them"
"Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
[vbcol=seagreen]
> Here is a reference:
> How to Script User and Role Object Permissions in SQL Server
> http://www.sql-server-performance.com/bm_object_permission_scripts.asp
> "sdmusicmaker" wrote: