You work as a database administrator at TestKing.com. TestKing.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 TestKing. 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.