Exam4Training

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

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

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version