February 24, 2003 at 10:32 am
Our application uses SQL-DMO to bulk load data into SQL Server 7 database tables. I had set up an application role for the users but this does not provide sufficient permissions. The application role was granted membership in the database role db_owner in the hope that this would allow the bulk process. This was not successful. It appears that the only way the application can perform the bulk load is to grant the fixed server role 'sysadmin' to the user logins (not application role) that will be running it. This is very unsettling! Is there any 'work-around' for this that will allow the users to bulk load the data without granting 'sysadmin' permissions? Are there any parameters that can be included in the SQL-DMO code that would allow non-sysadmin users to run the bulk process?
February 24, 2003 at 10:51 am
February 24, 2003 at 10:58 am
I believe that the bulk load server permissions is for SQL 2000. We are running SQL 7.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply