Still kind of confused on this.
After I create the Role and give the role appropriate access to the database, I would then do the following for existing users: modify the users to take away their DB_Owner access to the database and then add them to the MyRole.
For NEW users, I would do the following:
Add the new NT authenticated USer to the Server
EXEC sp_grantlogin 'Supreme\UserID'
Make the Database the default Database for this user:
sp_defaultdb 'Supreme\USerID', 'MyDatabase'
Add the user to the role:
sp_addrolemember 'MyRole', 'Supreme\userid'
Does that look like the logical sequence? did I miss anything?