Hello experts!
My company is finally moving from SQL 2005 to SQL 2016. Lots of changes to learn, but I'm curious about who the owner of the SSISDB should be. I created the catalog while I was logged in as me - so it has me as the owner. I'm sure that's not best practice, but I'm wondering if it should be SQL agent, or maybe SSIS. I plan to deploy and run my SSIS packages from the Agent, but having no experience with SSISDB I'm not sure who the owner should be. My databases are owned by sa, just not sure how, or if the owner affects how jobs are run in production. Or if I should treat the SSISDB the same as all databases and assign sa as owner.
I look forward to your suggestions! Thanks!
It would be same as DB owner and members role as far as I'm aware. SSIS_Admin will have admin access on SSIS DB and SSIS member will have member level access on SSIS DB. Anyway we can wait for our experts to comment 😀😀