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 views’ existing permissions. What
should you recommend?
A.
Drop the existing view and then recreate the view.
B.
Rename the existing view.
C.
Alter the existing view.
D.
Create a new view.
Explanation: