vceguide.com has a SQL Server 2008 database infrastructure that has a database named Production. The Production database has a number of views, each of which has custom permissions.
You need to develop a solution for the Production database that will allow vceguide.com developers to alter the views without affecting the views’ current permissions.
How would you accomplish this task?
A. By allowing the developers to create new views
B. By modifying the existing views.
C. By dropping and recreating the existing views.
D. By grating the DATE and ALTER permissions on the Production database to the developers.
E. By granting the CREATE SCHEMA permission to the developers.
F. By adding the developers to the db_owner role.
G. By adding the developers to the sysadmin server role.
H. By adding the developers to the dbcreator role.
