Question about the BulkAdmin

  • The BulkAdmin is a server-level role. After granted this role to a user, the user can bulk insert data to any database in the SQL instance.

    Can we restrict this privilege to a single user database?

    Is anything wrong in my above description?

    Many thanks in advance.

  • Granting bulkadmin doesn't actually give that person INSERT authority to any table.

    Any user would still need standard GRANT INSERT on a table or a role containing that authority to insert to the table.

    Bulkadmin simply allows them to do bulk inserts, for example, by using the BULK INSERT statement, against tables upon which they already have separate INSERT authority.

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply