To which role or roles should you add to UserC?

Posted by: Pdfprep Category: 70-462 Tags: , ,

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 UserC? Select all that apply.
A . db_accessadmin
B . db_ddladmin
C . db_datawriter
D . db_datareader
E . db_owner

Answer: A

Explanation:

User A = db_ddladmin

User B= db_datawriter, db_datareader

User C = db_accessadmin

Leave a Reply

Your email address will not be published.