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 sysadmin role.
B.
Add the developer to the db_owner role.
C.
Grant the developer the CREATE TABLE permission only.
D.
Grant the developer the CREATE SCHEMA permission only.
Explanation:
In SQL Server Enterprise Manager, if you do not belong to the db_owner database role, you cannot view existing diagrams or create new diagrams. When you try to create a new diagram, you receive the following error message: "You do not have sufficient privileges to create the new diagram." After you apply the db_owner database role, you can view existing diagrams and create new diagrams.