copy roles with their permissions from one db to another

[shanghai2004]

Dear Expert,

Followed the instructions below I copied the user and roles from one database to another. But the permissions of the roles were not be copied over. Is there a way to copy the permissions of the roles over?

Thanks


=====================
In Enterprise Manager

Right Click on your Database
Select "All Tasks"->"Generate SQL Script"
Select "Options"
Check "Script Database Users And Database Roles"
UnCheck everyting else
Select OK or.. Go back to the "General" tab and select "Preview"

 

[mrdenny]

Do the same thing, but also check the object permissions box. That might do the trick.

Getting permissions scripted can be tricky.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Jamfool]

MS provide a script way. check out
thread183-1208174

 

[onpnt]

speaking with little experience here but doesn't DTS give you the options to do this?

I'll refer back to my references but I thought it did


General FAQ faq333-2924
5 steps to asking a question faq333-3811