You are the administrator of a SQL Server 2008 instance. There is a database developer who is named UserJack. UserJack views the definitions of all database objects in a database to read data from…

You are the administrator of a SQL Server 2008 instance. There is a database developer who is named UserJack. UserJack views the definitions of all database objects in a database to read data from all user- defined tables, views, and table-valued functions. For UserJack, you have to assign the required permissions. Besides this, you must make sure that other developers can also be given the same permissions, but this should be achieved by executing as little Transact-SQL statements as possible. Which Transact-SQL statements should you execute?