What are the roles and permissions a SQL Server user must have in order to discover all SQL component information?
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 SQLAgentReaderRole in 'msdb'