temporary sysadmin rights

[Guest_imported]

Sql Server 7 only lets you run BULK INSERT from a storedproc
if user is in sysadmin group. Is there a way to let user
of Delphi program that calls the storedproc emulate being the sa? (Want user to control the timing of running of the Delphi program that does the BULK INSERT)

 

[Hal10K]

This should be easily done, with the cooperation of your DBA and NT Admins
1. NT Admin sets up account for the Delphi application to run in.
2. DBA sets up an NT login with appropriate role permissions
3. At the point your Delphi app runs, it could either
a. run the job in the NT login context or
b. fire a T-SQL job that would
i. grant permissions as appropriate
ii. run the job
iii. revoke the permissions

or
4. Look at the SQL Agent and the SQL AgentCMD proxy info

or
5. Use SQL-DMO and SQL-NS objects

-hal