BUG: Cannot Perform BULK INSERT with Bulkadmin Privileges

View products that this article applies to.

This article was previously published under Q302621

BUG #: 354213 (SHILOH_BUGS)

Expand all | Collapse all

SYMPTOMS

If a BULK INSERT command is issued by a user who

Is part of the bulkadmin server role and has INSERT permissions to the table
Is not part of the sysadmin, db_ddladmin, or db_owner role
Is not the database owner

The following error message is generated:

Server: Msg 8104, Level 16, State 2, Line 1
The current user is not the database or object owner of table '<table_name>'. Cannot perform SET operation.

Back to the top

To work around the problem, make sure that the user is also part of either the db_ddladmin or the db_owner database role in addition to the bulkadmin server role. Another workaround is to make the user the owner of the database.

Back to the top