Cannot perform BULK INSERT even though the account is a bulkadmin

From: Duck Dunn (x@outerinternet.com)
Date: 03/03/03 

From: "Duck Dunn" <x@outerinternet.com>
Date: Mon, 3 Mar 2003 11:47:37 -0800

We have a stored procedure that dynamically constructs a BULK INSERT
statement string and executes it. The account that executes this stored
procedure is not the DB owner or table owner, but has been given "Bulk
Insert Administrator" server role.

We get the following error while executing this stored procedure:

The current user is not the database or object owner of table
'PreStageOrganization_AATP'. Cannot perform SET operation.

Pl let us know what permissions are missing for this operation.

Thanks

Relevant Pages

  • VB-> ADO -> ORACLE
    ... I have a oracle procedure which executes a query to access external ... have permissions to run the external query in the stored procedure) i am ... when run from sqlplus both user1 and owner can execute the stored procedure ...
    (microsoft.public.data.ado)
  • Re: Cannot perform BULK INSERT even though the account is a bulkadmin
    ... Cannot Perform BULK INSERT with Bulkadmin Privileges ... Jasper Smith (SQL Server MVP) ... The account that executes this stored ... > procedure is not the DB owner or table owner, ...
    (microsoft.public.sqlserver.security)
  • HELP..
    ... I tried by making the owner of the job as 'sa' and starting the job manually ... >> SQL SERVER 7.0 ... >> I created a SQL job which executes a stored procedure. ...
    (microsoft.public.sqlserver.security)
  • SqlDataAdapter.Fill returns results of previous command
    ... This code executes successfully at certain points in the application, ... I don't know what the cause of this exception is yet, ... stored procedure was indeed executed on the database. ... The trace shows that the last action on the db was the stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help Isolating Data Access
    ... > I've set up a stored procedure that first queries the table for a record ... > The process that executes this stored procedure runs on multiple threads ... Is there a design pattern for ...
    (microsoft.public.dotnet.general)