RE: Microsoft SQL Server 2000 'BULK INSERT' Buffer Overflow (#NISR11072002)

From: Hall, Philip (phallat_private)
Date: Thu Jul 11 2002 - 07:57:03 PDT

  • Next message: Aaron C. Newman: "RE: Microsoft SQL Server 2000 'BULK INSERT' Buffer Overflow (#NISR11072002)" 

    > To be able to use the 'BULK INSERT' query one must have the 
> privileges of the database owner or dbo. Note this does not
> necessarily imply 'sa' equivalence.

In fact, you need to be a member of the sysadmin and bulkadmin fixed server roles to be able to execute BULK INSERT, both of these have to be explicitly set, if you're not user 'sa'

--phil

    This archive was generated by hypermail 2b30 : Thu Jul 11 2002 - 20:58:30 PDT