Import CSV without BULKADMIN permissions

• Clarie DeWayne

  Mr or Mrs. 500

  Points: 526

  More actions

  February 13, 2009 at 3:17 pm

  #197155

  I have an application that needs to import a CSV file into a temp table, then do a bunch of manipulations after that. However, I do NOT want to give the AppID the BULKADMIN server role for bulk import.

  So far, the only slightly feasible work around seems to be to have a sysadmin create the import job and have the AppID call a stored procedure with EXEC AS to get the higher level of rights. But that seems needlessly "clunky" to me.

  TIA for all assistance!

  Clarie

• Jeff Moden

  SSC Guru

  Points: 1004561

  More actions

  February 13, 2009 at 8:58 pm

  #944021

  Clarie Smith (2/13/2009)

  ---

  However, I do NOT want to give the AppID the BULKADMIN server role for bulk import.

  Why not? The only thing folks can do is execute a Bulk Insert statement with that role. The can't create or delete anything with it.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)