Re: Package Sercurity Context
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 03/02/04
- Next message: Darren Green: "Re: ActiveX script converting to datetime syntax"
- Previous message: Olivia: "ActiveX script converting to datetime syntax"
- In reply to: alien2_51: "Package Sercurity Context"
- Next in thread: KP: "Re: Package Sercurity Context"
- Reply: KP: "Re: Package Sercurity Context"
- Reply: alien2_51: "Re: Package Sercurity Context"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 2 Mar 2004 18:21:26 +0000
In message <ebqh0YHAEHA.1548@TK2MSFTNGP12.phx.gbl>, alien2_51
<dan.billow@?.o.s.p.a.m.monacocoach.commercialversion.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.aspx?scid=kb;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
- Next message: Darren Green: "Re: ActiveX script converting to datetime syntax"
- Previous message: Olivia: "ActiveX script converting to datetime syntax"
- In reply to: alien2_51: "Package Sercurity Context"
- Next in thread: KP: "Re: Package Sercurity Context"
- Reply: KP: "Re: Package Sercurity Context"
- Reply: alien2_51: "Re: Package Sercurity Context"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
