6. Which of the following database-level roles limits a user’s permissions to
reading all data from all user tables?
A. db_owner
B. db_datareader
C. db_datawriter
D. db_securityadmin
The correct answer is B. The role of db_datareader will limit a user to being
able to only read all data from all user tables. Answer A would provide the user
with permissions greatly exceeding his needs. Answers C and D would not
provide the user sufficient permissions to read the data.
Bạn đang xem 6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P145 PPSX