PrepAway - Latest Free Exam Questions & Answers

You administer a database that has User A, B and C.

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


Leave a Reply