PdfPrep.com

To which role or roles should you add to UserB?

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

Answer: C,D

Explanation:

User A = db_ddladmin

User B= db_datawriter, db_datareader

User C = db_accessadmin

Exit mobile version