CCA Discovery: Required SQL user permissions for SQL Blueprint discovery

Document ID : KB000047989
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

What are the roles and permissions a SQL Server user must have in order to discover all SQL component information?

Solution:

The SQL Server user (login) for SQL Blueprint discovery must have the following permissions:

  • Server role 'public'

  • Grant VIEW ANY DEFINITION

  • Grant VIEW SERVER STATE

  • User created (for the login) in each database with 'db_datareader'

    database role

  • Database role SQLAgentReaderRole in 'msdb'