Microsoft Exam Questions

which role or roles should you add the users?

You administer a database that has User A, B and C
User A must be able to create new tables and stored procedures, User B must be able to select,
update, delete and insert data.
User C must be able to provide windows logins to the database
To which role or roles should you add the users?

A.
db_accessadmin

B.
db_ddladmin

C.
db_datawriter

D.
db_datareader

E.
db_owner

Explanation: