Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shakana
Starting Member
6 Posts |
 Posted - 2004-09-08 : 15:27:31
|
| I want to do a bulk insert into a temporary table (#tablename). The reason I want to use temporary tables is to handle multiple user simultaneously performing this function. I can only get this to work successfully if I make the user the System Administrator. Is this the minimum permission set I need to grant the user in order to get this to work?-Andre |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 15:31:59
|
From SQL Server Books Online:quote:
Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
You should not grant this access though. BULK INSERT should only be performed by the DBA/System Administrator. You should rethink your design.Tara |
 |
|
|
shakana
Starting Member
6 Posts |
Posted - 2004-09-08 : 17:58:54
|
| The Bulk Insert does work with just the bulkadmin server role if the table is not a temporary table. The informaton is coming from a flat file so Bulk Insert seems to be a good choice.-Andre |
|
|
|
|
|
|
Permissions to Bulk Insert into Temp Tables