April 22, 2010 at 10:13 am
Hi All
I wonder if you can help. Some of my DBOs have requested the ability to use the Bulk Insert command. I have one server with many databases on it, each database has a DBO and they have permissions on their database only so they can't mess things up too much for the other DBOs. I am trying to understand the implications of allowing these users to use Bulk Insert command, as I understand it, the only way of doing this is to make them a member of the BULKADMIN server role. I am struggling to find more information about this role, if I give my users this permission, does it mean they could do something that would could mess things up for my other databases (like accidently import into their database or into the tempdb)?
Thanks, in advance, for your help!
April 23, 2010 at 4:24 am
I have found the information now, but am posting a link to the article (from this site) that answered my question. The article is old (it relates to SQL 2000) but the information on the server roles is still applicable to SQL 2008.
http://www.sqlservercentral.com/articles/Administration/sqlserversecurityfixedroles/1163/#
Excellent article! Thanks again to SQL Server Central!
November 28, 2016 at 11:13 pm
Was looking for this info! Thanks for the link!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply