Bug for QOD 13 aug 2003
-
There is a known bug with bulk insert and the role 'bulk insert admin': BUG: Cannot Perform BULK INSERT with Bulkadmin Privileges (302621) .
Even if the deny is removed, Mary would not be able to bulk insert. So 'never' surely was correct. She needs to be in the role 'db_ddladmin' or 'db_owners' to make it work.
-
I found the same problem. Upon trying out the scenario I found that Mary couldn't BULK INSERT into dbo.orders, even without the DENY in place.
I figured it must be a trick question and that the table was actually mary.orders. I based my answer on this assumption.
Given that this is a perfectly logical explanation, can I have my points back?
Cheers,
- Mark
Cheers,
- Mark -
quote:
Given that this is a perfectly logical explanation, can I have my points back?no!
You scored 3 points the day. That's balancing justice
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
That's about as much sympathy as I expected.
Cheers,
- Mark
Cheers,
- Mark -
quote:
That's about as much sympathy as I expected.always at your service
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Btw, Mark, I scored those two points
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply