Security considerations on Importing Bulk Data by Using BULK INSERT or OPENROWSET(BULK...)
- by Ice
I do not understand the following article profound.
http://msdn.microsoft.com/en-us/library/ms175915(SQL.90).aspx
"In contrast, if a SQL Server user logs on by using Windows Authentication, the user can read only those files that can be accessed by the user account, regardless of the security profile of the SQL Server process."
What if i define a SQL-Agent Job to perform this bulk-Insert; Is it the OWNER of the Job who gives the security-context?