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:
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
0
0
DDLADMIN
0
0
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.
0
0
what is the answer as per drag and drop to each user?
0
0
A = ddladmin
B=datawriter, datareader
C=accessadmin
0
0
User A = db_ddladmin
User B= db_datawriter, db_datareader
User C = db_accessadmin
https://technet.microsoft.com/en-us/library/ms175039(v=sql.90).aspx
0
0