Security considerations on Importing Bulk Data by Using BULK INSERT or OPENROWSET(BULK...)
Posted
by Ice
on Super User
See other posts from Super User
or by Ice
Published on 2010-05-06T16:47:15Z
Indexed on
2010/05/06
16:48 UTC
Read the original article
Hit count: 449
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?
© Super User or respective owner
