December 5, 2022 at 5:41 pm
Hi Gary, I know this is an old post. I am very interested in this suggestion. Did you successfully create the Sp to take ownership and another Sp to revert the ownership to the SSIS account?
December 5, 2022 at 10:12 pm
Please look into the database ROLES for MSDB. There a 3 that are totally different than they are in any other database. They'll be obvious to you. Then, look them up to see what each does. for privs.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy