January 18, 2018 at 9:56 am
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!
January 18, 2018 at 10:01 am
Shaira - Thursday, January 18, 2018 9:56 AMOr if I should treat the SSISDB the same as all databases and assign sa as owner.
^^This.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 6, 2018 at 7:28 am
Shaira - Thursday, January 18, 2018 9:56 AMHello 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 😀😀
February 6, 2018 at 7:35 am
subramaniam.chandrasekar - Tuesday, February 6, 2018 7:28 AMIt 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 😀😀
So ... you are suggesting that the DB owner for SSISDB should be the same as ... erm ... the DB owner. Not sure what you mean by that.
SSIS admin is granted via a database role within SSISDB, not via DB owner.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply