You are a database administrator for your company. Your company stores all its product data in a SQL Server2005 database named Products. You upgrade the Products database to SQL Server 2008. After the upgrade,you create the respective logins and users in the new database on SQL Server 2008. Eric, a user in your database, complains that since the upgrade he is not able to access the tables created byanother user, Adam, through a stored procedure. However, Adam is able to access the tables through the storedprocedure.
You need to ensure that Eric is able to access the data while minimizing excessive permissions. What should you do?