BUG: Cannot Perform BULK INSERT with Bulkadmin Privileges (302621)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q302621
BUG #: 354213 (SHILOH_BUGS)

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.

WORKAROUND

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.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbbug kbpending KB302621
©2003 Microsoft Corporation. All rights reserved.