We using IPAM 4.8.1 and are planning to migrate from SQL Server Express to a Shared SQL Server instance as per: Migrate the SolarWinds Orion SQL database to a new server - SolarWinds Worldwide, LLC. Help and Support
As the new SQL Server instance is shared with other applications, we have a restriction that the database user (SolarWindsOrionDatabaseUser) cannot be part of the sysadmin role. The highest permitted level is dbo (dbowner).
I was wondering why the sysadmin role is required and the impacts of downgrading this to dbowner?
Any thoughts much appreciated.