Bulk Insert Permissions

From: Ysandre (Ysandre_at_discussions.microsoft.com)
Date: 10/15/04 

Date: Thu, 14 Oct 2004 18:49:03 -0700

We have a stored procedure that includes the following statement:

delete TableA
bulk insert TableA
from 'c:\File\Folder\Data.csv'
with (firstrow = 2,
fieldterminator = ',')

We are trying to create a SQL user with just enough permissions to the DB to
be able to select, insert, delete, and execute . . but stopping short of
System or db_owner access.
User has the following database roles: public, datawriter, datareader, and a
specific database role we created with access to all tables and sp's in that
db.
User has the following server role: Bulk Insert Administrator.

Problem:
We get the following error when trying to execute the above bulk insert:
The current user is not the database or object owner of table
'ClientDatabase.dbo.TableA'. Cannot perform SET operation.

The only way to not get this error is to grant the user the db_owner role,
which we don't want to do.

Any other ideas? Is there a table permission somewhere we need to change? Or
another database role that would allow this insert? Why isn't the Bulk Insert
Administrator server role enough?

Thank you!!! 

-- 
Financial Systems Analyst
CCNA, MCSE, MCSA, MCDBA
Quantcast