You attempt to query sys.dm_db_index_usage_stats to check the status on the indexes in the Contoso database. The query fails and you receive the following error:

"The user does not have permission to perform this action." You need to have the least amount of permissions granted to access the dynamic management views. Which permissions should be granted?

Question

You attempt to query sys.dm_db_index_usage_stats to check the status on the indexes in the Contoso database. The query fails and you receive the following error:

"The user does not have permission to perform this action." You need to have the least amount of permissions granted to access the dynamic management views. Which permissions should be granted?

Accepted Answer

B. VIEW SERVER STATE

Answer

A. CONTROL

Answer

C. VIEW DATABASE STATE

Answer

D. CREATE EXTERNAL ACCESS ASSEMBLY

You attempt to query sys.dm_db_index_usage_stats to check the status on the indexes in the Contoso database. The query fails and you receive the following error: "The user does not have permission…

Question

Options

How the community answered

Community Discussion