Copy users and roles

Question

Post reply

Copy users and roles

balbirsinghsodhi

SSCrazy Eights

Points: 9210
More actions
October 23, 2003 at 10:39 am

#82455

Can I copy users and roles from one database to another database on the same server.
I already copied logins and stored users and roles on one database but I want to copy users and roles from that database to another database on the same server.
Thanks in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sopheap Suy SSCertifiable Points: 7893 More actions · Answer 1

yes you can. There are also tools that you can use to do this. It depends if you have them available at your site.

mom

Johan Bijnens SSC Guru Points: 135375 More actions · Answer 2

script it from the old db and run the script on the new db, removing the script-references to the old db.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

balbirsinghsodhi SSCrazy Eights Points: 9210 More actions · Answer 3

How can you create a Users and Roles script from old database. There is no way to create a User and Roles script on the database.

Shas3 Hall of Fame Points: 3671 More actions · Answer 4

There is no way you can script the users and roles in the EM, unless you come up with a custom scripts. If the users are quiet a few I would suggest you manually grant the access to the other database, if there is more users write a script to capture the current permissions, after that change the database name in the script and execute it

Shas3

Johan Bijnens SSC Guru Points: 135375 More actions · Answer 5

with EM you'll have to script all and extra check-select script user-permissions and roles. It's not on by default and is to be found on the same tabpage where you select to script the indexes, ....