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?