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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-08-09 : 15:17:58
|
| Hi all,I have a package that runs perfectly.I used dtexec to run it from the stored procedure and it works fineBut when I call the stored procedure through coldfusion code It gives an error that user does not have permission to perform this action.The creator of the package is xxx and coldfusion is yyy.Can we use any switched in dtexec to tell him run it as xxx user.Thankssarah |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-08-09 : 16:28:49
|
| what security context is the coldfusion using to run dtexec?If you don't have the passion to help people, you have no passion |
 |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-08-09 : 23:37:30
|
| Coldfusion is represented as login (sql authenticated on sql server)sarah |
|
|
|
|
|
|
use dtexec to run a package as a particular user