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:
> 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.|||You will need to edit the output script for the specific users you need to
transfer.
"sdmusicmaker" wrote:
> 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:
> > 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.|||not sure i know what you mean?
"Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
> You will need to edit the output script for the specific users you need to
> transfer.
> "sdmusicmaker" wrote:
> > 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:
> >
> > > 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.|||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:
> not sure i know what you mean?
> "Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
> > You will need to edit the output script for the specific users you need to
> > transfer.
> >
> > "sdmusicmaker" wrote:
> >
> > > 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:
> > >
> > > > 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.|||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:
> 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:
> > not sure i know what you mean?
> >
> > "Edgardo Valdez, MCTS, MCITP, MCSD, MCDBA" wrote:
> >
> > > You will need to edit the output script for the specific users you need to
> > > transfer.
> > >
> > > "sdmusicmaker" wrote:
> > >
> > > > 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:
> > > >
> > > > > 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.