Page History
...
Account | Action | Permissions required |
---|---|---|
Windows User Account | To install IDERA SQL Inventory Manager components | Windows Administrator permission on the Target computer |
To create and access the IDERA SQL Inventory Manager repository databases |
| |
SQL Server login account | For most SQL queries | VIEW SERVER STATE VIEW ANY DATABASE VIEW ANY DEFINITION |
To monitor database information | ALTER ANY DATABASE server level permission or CREATE DATABASE in the master database | |
For DBCC CHECKDB | sysadmin server roles | |
Linux | To install SQL Inventory Manager Repository on a Linux SQL Server |
|
To query Linux Server Info |
|
...