Which permission should you grant?

A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Databaseinstances. The environment hosts a customer database named DB1.

Customers connect to hosted database instances by using line-of-business applications. Developers connectby using SQL Server Management Studio (SSMS).

You need to grant the developers permission to alter views for DB1 while following the principle of leastprivilege.

Which permission should you grant?
A . DDLAdmin
B . db_datawriter
C . dbcreator
D . dbo
E . View Database State
F . View Server State
G . View Definition
H . sysadmin

View Answer

Answer: A

Explanation:

To execute ALTER VIEW, at a minimum, ALTER permission on OBJECT is required.

Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in adatabase.

References: https://technet.microsoft.com/en-us/library/ms190667(v=sql.90).aspx