You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
You have been informed that a database designer, named Andy Reid, requires the necessary
permissions to view the definitions of all database objects in a database. You are also informed
that you will be assigning the same permissions to other designers in the near future.
You want to make sure that the entire process requires as little Transact-SQL statements as
possible.
Which of the following actions should you take?
A.
You should consider making use of the CREATE USER Transact-SQL statement.
B.
You should consider making use of the WORKLOAD GROUP Transact-SQL statement.
C.
You should consider making use of the CREATE ROLE Transact-SQL statement.
D.
You should consider making use of the APPLICATION ROLE Transact-SQL statement.
Explanation: