Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2000
SQLXML
 Bulk Load Security Issues

  Switch on low bandwidth view
SQLXML 3.0 Service Pack 3
Bulk Load Security Issues

When you specify that a bulk load operation is to be performed as a transaction, you use the TempFilePath property to specify a folder in which to create the temporary files.

The bulk load process creates these temporary files with the following permissions:

  • Read/Write/Delete access is granted to the bulk load process.

  • Read permission is granted to all users, because the account under which Microsoft® SQL Server™ is going to access these files is unknown. You can restrict the access to these temporary files by setting the appropriate permissions on the folder that contains them.
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker