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:

Show Hint

← Previous question

Next question →

Leave a Reply 6

Razor

Question is Incomplete. Here is the complete Question.
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 albe to provide windows logins to the database

db_accessadmin
db_ddladmin
db_datawriter
db_datareader
db_owner

To which role or roles should you add the users?

A.
ddladmin
B.
datawriter, datareader
C.
accessadmin

Correct Answer: A

God

DDLADMIN

peter.pan

This question looks a diferent in my real exam test. It is a drag&drop question, on left side are UserA, UserB, UserC. On right side are roles datawriter, datareader, accessadmin and db_owner. You must assign users from left side to roles on right side.
Maybe exists a more variants of this question, but question in the original post is mishmash and IMHO doestn exist correct ansnwer. Ddladmin for all three user is overkill and is it a very bad security practice in this case i think.