 | |
Package Sercurity Context
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Package Sercurity Context -
03-02-2004
, 10:48 AM
#2
| |||
| |||
|
|
Under what security context does an ActiveX Script task run as if executed inside the DTS designer...? Where does it get the context, does it impersonate the user..? I realize that it's different when run as a scheduled job, whatever credentials the SQL Agent runs under are used... Is that correct..? TIA The script and indeed the package is run under the context of the user |
Manager for example it runs on the same machine as EM, under the user
context of logged on user.
If you schedule a package then you basically get the SQL Server Agent
service to call DTSRUN for you, so it is on the same machine as SQL
Server Agent and running under the SQL Server Agent service account. The
caveat to that is for jobs not owned by a sysadmin SQL agent then
impersonates the proxy account, assuming one has been defined.
More info about scheduled packages here-
http://support.microsoft.com/default...b;en-us;269074
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#3
| |||
| |||
|
|
Is there any way (may be using a script or getting information out of system tables etc.,) to figure out under what user / service account one particular package is running? The reason for this question is I have around 500 packages spread all over my network. Its almost impossible to find out which account is in use for a specific package manually. TIA KP |
and the sysadmin column. sysadmins use the SQL Agent account, other
users get the proxy account.
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
#4
| |||
| |||
|
|
In message <ebqh0YHAEHA.1548 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, alien2_51 dan.billow@?.o.s.p.a.m.monacocoach.c...versi on.invalid> writes Under what security context does an ActiveX Script task run as if executed inside the DTS designer...? Where does it get the context, does it impersonate the user..? I realize that it's different when run as a scheduled job, whatever credentials the SQL Agent runs under are used... Is that correct..? TIA The script and indeed the package is run under the context of the user executing the package. DTS is client-side, so when using Enterprise Manager for example it runs on the same machine as EM, under the user context of logged on user. If you schedule a package then you basically get the SQL Server Agent service to call DTSRUN for you, so it is on the same machine as SQL Server Agent and running under the SQL Server Agent service account. The caveat to that is for jobs not owned by a sysadmin SQL agent then impersonates the proxy account, assuming one has been defined. More info about scheduled packages here- http://support.microsoft.com/default...b;en-us;269074 -- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.