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 database
s
> 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.c...ion_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.c...ion_scripts.asp
> "sdmusicmaker" wrote:
>