sql server bulk insert permisisons

Question

if the login is a member of the db_owner on the master database, does it need explict permisions for bulk insert

or does the role db_owner for master already include bulk insert operation permissions.

Answer 1

To perform BULK INSERT or OPENROWSET(BULK) You need to have the server permission ADMINISTER BULK OPERATIONS or be a member of the fixed server role bulkadmin.

Normally, there would not be any members in db_owner in master outside those who are members of sysadmin. But in any case, permissions or role membership on database level, does not give you server-level permissions, and that is what is needed here.

Answer 2

is there any Microsoft documentation to show that db_owner includes bcp permissions