Bulk Insert Permissions

Last Post 01 Jan 2007 06:13 PM by bal. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
bal
New Member
New Member

--
28 Dec 2006 04:08 PM
Does any one know if the following bug ever got fixed in sql server KB302621.

Basically if you are not the owner of the object you are trying to bulk load data into and are a member of the BULk Addmin group you still need to be a member of either the ddl_admin or db_owner groups. If you are not a member od these groups you get the message:-

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.

Thanks.
bal
New Member
New Member

--
01 Jan 2007 06:13 PM
yes we are at 8.00.2039 sp 4.

I don't think this has been fixed in any of the Service packs, thats why I raised the question on the forum.

It looks like Msoft have just left it with the work around solution.


Acceptable Use Policy
---