Post reply

Import CSV without BULKADMIN permissions

  • 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

  • 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)
    Intro to Tally Tables and Functions

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

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