Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2007-07-09 : 15:58:25
|
| I have a SSIS package developed by a different user which does a lot of DML. This package sits on the server. The package needs to be executed on a regular basis. I have given RO access for a regular user on production DB, he is executing the package from his client desktop. I was expecting this execution fail, since the package is doing lot of INSERTS , where the user has ONLY RO access. I understand from the above experience that there is an “execution context” for SSIS execution. Can someone tell me how can I define the execution context for SSIS? ------------------------I think, therefore I am - Rene Descartes |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-09 : 16:43:42
|
| Which account used in the package to talk to sql server? |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-07-09 : 17:04:17
|
| windows authentication!------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Execution context for SSIS