Re: Cannot perform BULK INSERT even though the account is a bulkadmin
From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 03/03/03
- Next message: Jasper Smith: "Re: analysis services connection"
- Previous message: Bill Harbour: "Deleting a user that is an object owner"
- In reply to: Duck Dunn: "Cannot perform BULK INSERT even though the account is a bulkadmin"
- Next in thread: Jasper Smith: "Re: Cannot perform BULK INSERT even though the account is a bulkadmin"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Jasper Smith" <jasper_smith9@hotmail.com> Date: Mon, 3 Mar 2003 22:03:15 -0000
It seems that you require at least insert permissions plus
ddl_admin or db_owner to bulk insert into a table you
don't own when you are a non sysadmin using dynamic sql
When you use dynamic sql, all object permissions are checked
for the user running the command. Thus you need insert rights
to put the data in the table plus the fact you don't own the table
means you need to be ddl_admin or db_owner because the
BULK INSERT command seems to be setting some SET option
that requires a permission on the table that only those two roles
can give you. You really don't want to give those rights to joe user
though. This doesn't actually seem related to dynamic sql. Even
using hard coded values in a procedure causes this error.
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Duck Dunn" <x@outerinternet.com> wrote in message news:3e63b159$1@news.microsoft.com... > 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 > >
- Next message: Jasper Smith: "Re: analysis services connection"
- Previous message: Bill Harbour: "Deleting a user that is an object owner"
- In reply to: Duck Dunn: "Cannot perform BULK INSERT even though the account is a bulkadmin"
- Next in thread: Jasper Smith: "Re: Cannot perform BULK INSERT even though the account is a bulkadmin"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
