You need to grant users access according to the following requirements: CORP\Employees should have SELECT access to the Employees table
You need to ensure that database users and required server logins are migrated to Windows Azure SQL Database