Does the user have Delete/Insert privileges on the tables being operated on?

Richard

>My client has an application that is a monthly close process. It copies data from current tables to history tables of identical structure; all tables are in the same SQL database. I have run the process successfully many times but the local operator of the system receives the following error message.
>
>Connection failed: SQLState: 08004 SQL Server Error: 4060 Server rejected the connection; Access to selected database has been denied.
>
>Oddly, the error doesn’t occur at the initial connection to the database, but appears later during the actual processing of the tables, leading me to wonder if it could have something to do with her permissions or roles (my logon has full privileges on the server.) The commands used for processing the tables follow this format
>
>INSERT INTO history SELECT FROM dbo.current current WHERE conditions; SELECT @@rowcount AS nRows.
>
>and
>
>DELETE current WHERE same_conditions.
>
>This user is a member of a group with public, db_datareader, and db_datawriter roles. Does she also need one or more server roles? If so, which ones? SQL Books Online identifies the bulkadmin server role for using the SQL bulk insert statement but the application doesn’t directly use this command. Since the application is being supported remotely, the trial and error process will be rather tedious so any help would be appreciated.