COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The user with this permission can view activity monitor and execute server-level DMVs and DMFs; if the user is granted VIEW DATABASE STATE Permissions, he can execute database-level DMVs and DMFs.
Detailed explanation-2: -SQL Server’s ‘View server state’ permission is a high server-level privilege that must only be granted to individual administration accounts through roles. This administrative privilege must not be assigned directly to administrative user accounts (or any other user accounts).
Detailed explanation-3: -Required Permissions To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission. This lets you selectively restrict access of a user or login to dynamic management views and functions.
Detailed explanation-4: -Click Permissions, and then click View server permissions. In the Logins or Roles list, click the user to whom you want to grant the permission. In the Explicit permissions for user list, click to select the Grant check box next to View server state permission.