You need to provide a developer the ability to create and modify database diagrams from an
existing database by using SQL Server Management Studio. The solution must minimize
the amount of permissions assigned to the developer. What should you do?

A.
Add the developer to the db_owner role.

B.
Grant the developer the CREATE TABLE permission only.

C.
Add the developer to the sysadmin role.

D.
Grant the developer the CREATE SCHEMA permission only.

Explanation: