Why won't dbo.sysssislog be written to if proxy account is executing the package

Question

So we setup ssis logging in the package - Run the packaged in Studio, no problem writes to table. Publish it to SSIS and run it using the sql server agent account and it again writes to that sysssislog table. However if we run it as a proxy account it no longer writes to that table and isn't generating errors anywhere. The credential for the proxy account has db_owner on the database used in the connection. Even though it has db_owner we granted execute on dbo.sp_ssis_addlogentry on the DB and MSDB just in case. still no dice. If we grant the credential SysAdmin to the server, then it writes out to that table. Obviously we don't want to grant a proxy credential that access, but I am obviously missing a permission SOMEWHERE that allows me to do this. Any ideas!?

Thank you!
Jay

Answer 1

Hi @Spatz, Jason W ,

You may try to set the account for column-level permissions.

In this way you could give the account permission to write the dbo.sysssislog without granting credential SysAdmin.

Take a reference: filtering-sql-server-columns-using-column-level-permissions

You may have a try to see if it will be helpful.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October