Grant Bulk Insert Restrictions

• TJ_T

  Old Hand

  Points: 352

  More actions

  May 7, 2019 at 6:14 pm

  #3637305

  Hi,

  Is it possible to restrict Bulk Insert permissions?  Let's say you want to grant BULK INSERT for Temporary tables only.  Can this be done?

   

  Thanks,

   

  TJ

• oogibah

  SSC Eights!

  Points: 827

  More actions

  May 7, 2019 at 6:41 pm

  #3637322

  GRANT BULK INSERT ON [TEMPDB] TO [User]

  would work wouldnt it? .. granted I don't know enough about tempdb to know how destructive something like this could be

  • This reply was modified 5 years, 11 months ago by  oogibah.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  May 7, 2019 at 10:35 pm

  #3637657

  You can't grant the bulk operations on a particular database.

  For bulk insert, the server level permissions of Administer bulk operations needs to be granted to the login or add the login to bulkadmin server role. And then insert permissions. If there are constraints or they need to fire triggers, they need alter table permissions. But if they don't have insert permissions, they can't bulk insert into that table. So not granting insert on the other tables or not having access to a database would prohibit bulk operations against those tables.

   

  Sue