You are designing a maintenance strategy for a database that contains several views. The views will be assigned custom permissions. You need to recommend a solution that will allow developers to modify the views without affecting the view’s existing permissions. What should you recommend?
A.
Create a new view.
B.
Alter the existing view.
C.
Rename the existing view.
D.
Drop the existing view and then recreate the view.