SSIS Login Role permission to insert data into table?

  • Hi, I didn't see a forum for SSIS 2008, so am posting here.

    When assigning permission to an authentication user to connect to a server database, if I want the user to be able to insert / update / delete data on db objects specifically tables, what permission should be assigned to that user?

    My thoughts were Insert / Update / Delete; however, someone suggested that the Execute permission would do this ...

  • add the user to the role db_datawriter.

    Gerald Britton, Pluralsight courses

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply