You can use DTS to copy SQL objects, including users and roles.
Originally posted by rstout
I have a data base that will have to be recreated each year. I need to copy the users and roles and the security for the tables to the new database. All the tables will be the same.