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

Sopheap Suy

SSCertifiable

Points: 7893

October 23, 2003 at 11:56 am

#479345

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: 134873 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

balbirsinghsodhi

SSCrazy Eights

Points: 9210

November 7, 2003 at 4:47 pm

#481337

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: 134873 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, ....