Authentication

[vbodanki]

What is the answer for the below question and explain the answer.

You are a database developer. Andrea is also other member of your group. Andrea needs to alter views. But you need to prevent her from viewing and changing tables. Now she belongs to the public database role.

A. Add her to the db_owner database role.
B. Add her to the db_ddladmin database role.
C. Grant her create view permission.
D. Grant her ALTER view permission.

[skhanal]

The closest answer would be D, but to alter a view you need ALTER VIEW privilege plus SELECT permission on base tables so you can't have user alter view and not view the table data.

The question is not correct.