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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Copy User permissions

Author  Topic 

BruceT
Yak Posting Veteran

78 Posts

Posted - 2011-06-16 : 13:33:00
Hi,

First, I've read through the posts about transferring logins from one server to another etc. I did not see anything the might help with my particular problem, of course doesn't mean it's not there, I just might have a case of visual paralysis

Anyway, I have a customer with a test/training db with hundreds of logins with various and sundry permissions. They now want to switch to a live db (on the same server) and need to enable/copy the logins/permissions on the live db from the training db. Can anyone point me to a script that can help with that?

Thanks

BruceT
Yak Posting Veteran

78 Posts

Posted - 2011-06-16 : 13:47:40
Thanks, I think I found something that will work.
Go to Top of Page

stockholmpost
Starting Member

5 Posts

Posted - 2011-06-17 : 06:48:48
quote:
Originally posted by BruceT

Thanks, I think I found something that will work.



Hi BruceT,

Can you share with us ?

thnx
Go to Top of Page
   

- Advertisement -