You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instructions from management to configure the following:
* The required permission for Clerk and other users at Domain.com.
You need to complete this task with the least amount of SQL administrative statements.
What should you do?
A.
You should consider adding the following:
CREATE ROLE Developers;EXEC sp_addrolemember ‘sp_dbdatareader’, ‘Developers’;
EXEC sp_addrolemember ‘sp_dbddladmin’, ‘Developers’;
EXEC sp_addrolemember ‘Developers’, ‘ Clerk’;
B.
You should consider adding the following:
DROP ROLE Developers;GRANT VIEW DEFINITION TO Developers;
GRANT SELECT TO Developers;
EXEC sp_addrolemember ‘Developers’, ‘Clerk ‘;
C.
You should consider adding the following:
CREATE ROLE Developers;
GRANT VIEW DEFINITION TO Developers;
GRANT SELECT TO Developers;
EXEC sp_addrolemember ‘Developers’, ‘Clerk ‘;
D.
You should consider adding the following:
GRANT VIEW ANY DEFINITION TO ‘Clerk;
EXEC sp_addrolemember ‘db_datareader’, ‘Clerk ‘;