Microsoft SQL Server Roles and Privileges
This section outlines the required Microsoft SQL Server roles, and the user privileges and RCU schema roles needed to ensure secure, successful deployment.
Database users must be assigned ownership of the database, which provides DB_OWNER privileges, and BULK_INSERT.