should I create a db role first or db user first?

[shanghai2004]

Dear Export,

After I created a new database, should I create a db role first or create a db user first?
A Login for the db user exists already.

Is there an easy way to copy users/roles from one database to another?

Thanks

 

[SQLBill]

Yes. It doesn't matter which comes first.

Microsoft has a script that will let you copy off all the users as a TSQL script. I have the script at work, but unfortunately, I'm at home until Monday. Maybe someone else has that information.

-SQLBill

Posting advice: FAQ481-4875