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 |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2004-02-24 : 15:55:58
|
| Continuing on the bulk insert theme...I see in BOL that sysadmin privileges are required to do Bulk Insert.I need to offer my non-sysadmin users a web-based application (ASP)that passes variables to an SPROC where BULK INSERT is used to create a temp table that receives data from a text file they have designated.Once Bulk Insert is run, the temp table is updated, altered, and its data is eventually used to UPDATE a regular SQL Server 7.0 table.Is there any way to work around permissions issues to allow these non-admin users to launch the SPROC in SQL Server 7.0? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-24 : 15:58:14
|
| "Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT."So grant them bulkadmin fixed server role.Tara |
 |
|
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
Posted - 2004-02-24 : 16:08:48
|
| Is there a bulkadmin role in sql server 7.0? I didn't see it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-24 : 16:12:49
|
| Oh SQL 7.0. Not sure as I haven't worked on 7.0 in over 2 years now. Check BOL for which are available. If your 7.0 BOL says that only sysadmin can run BULK INSERT, then you won't be able to use BULK INSERT unless you grant sysadmin. SQL 2000 BOL says sysadmin and bulkadmin. So you could use bcp.exe in your application. It requires much less permissions.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-25 : 02:11:14
|
| You can create a job which executes commands from a table. Put the bulk insert command in the table and wait for the job (run as sysadmin) to execute it.Has to be a global temp table.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
can non-sysadmins do Bulk Insert somehow?