To which role or roles should you add the users?

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 the users?
A . db_accessadmin
B . db_ddladmin
C . db_datawriter
D . db_datareader
E . db_owner

Answer: A,B,C,D

Leave a Reply

Your email address will not be published.