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 to UserB? Select all that apply.
A . db_accessadmin
B . db_ddladmin
C . db_datawriter
D . db_datareader
E . db_owner
Answer: C,D
Explanation:
User A = db_ddladmin
User B= db_datawriter, db_datareader
User C = db_accessadmin