Hi @NeophyteSQL ,
As following illustrator, you can see db_owner role has all permissions in the database, and the permission of db_owner role including ADMINISTER DATABASE BULK OPERATIONS.
In order to execute BULK INSERT, the user must be granted ADMINISTER BULK OPERATIONS permission. This can be done either by granting the permission directly to the user or by adding the user to the bulkadmin role.
Grant a user ADMINISTER BULK OPERATIONS permission:
GRANT ADMINISTER BULK OPERATIONS TO [DOMAIN\USER]
Add a user to the BULKADMIN role:
ALTER SERVER ROLE [BULKADMIN] ADD MEMBER [DOMAIN\USER]
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.