What other steps are required?

UESTION NO: 36
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. You have received instructions from your boss, Miss Tess King, to comply with a new set
of users that will be hired by ABC. The first user is KeithClark. Later a new group of users named
Hirelings will be added as well. They should all be able to:
•view the definitions from all user-defined tables
•read data from all user-defined tables
•read data from all user-defined views
•read data from all user-defined functions
You need to complete this task with the least amount of SQL administrative statements. You start
by created the user KeithClark.
What other steps are required? Select all that apply.

A.
DROP ROLE Hirelings;

B.
CREATE ROLE Hirelings;

C.
GRANT VIEW DEFINITION TO Hirelings;

D.
GRANT VIEW ANY DEFINITION TO KeithClark;

E.
GRANT SELECT TO Hirelings;

F.
EXEC sp_addrolemember Hirelings, ‘KeithClark’;

G.
EXEC sp_addrolemember ‘sp_dbdatareader’, ‘Hirelings’;

H.
EXEC sp_addrolemember ‘db_datareader’, ‘KeithClark’

I.
EXEC sp_addrolemember ‘sp_dbddladmin’, ‘Hirelings’;

J.
EXEC sp_addrolemember ‘Hirelings ‘, ‘KeithClark ‘;

Explanation:

Create a new role.
Give the role the appropriate permissions.
Add KeithClark to the new role.