Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Map Role to Database

Author  Topic  sinva Starting Member 23 Posts Posted - 2010-06-03 : 18:50:04 Hi all, I have hundreds of users assigned to a role in one database and I am now migrating my users to another in the same machine. How could I map the role to the new database like mapping user to database so that even I create any users in the future, the users could access the new database if I assigned them to the role? Thanks for all help