February 13, 2009 at 3:17 pm
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
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply