Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a database named DB1 that includes a table named sales .orders. You grant a user named User1 select permissions on the Sales schema.
You need to ensure that User1 can select data from the sales .orders table without specifying the schema name in any Transact -SQL statements.
Solution: You set the default database for User1 to DB1.
Does the solution meet the goal?