Re: SQL server jobs owner
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Wed, 23 May 2007 06:24:44 -0600
It depends on what the step is doing and what server roles
the job owner belongs to. T-SQL job steps don't use proxies
and whether the job is owned by a sysadmin or not all impact
the security context. For non-t-sql job steps such as
CmdExec or Activex script, If the job owner is a sysadmin,
then it executes under the security context of the SQL Agent
service account. If the job is owned by a non-sysadmin, it
executes under the security context of the proxy account.
For T-SQL steps that don't use proxies, it executes under
the job owners security context.
See books online topics: Creating Job Steps and Creating SQL
Server Agent Proxies.
-Sue
On Wed, 23 May 2007 00:40:00 -0700, Jack
<Jack@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Which login runs the sql server jobs: Is it the login defined as owner on the
job or is it the login defined on sql server agent. Thanks
Jack
.
- Prev by Date: Re: SQL server jobs owner
- Next by Date: Re: SQL 2000 table deleted...
- Previous by thread: Re: SQL server jobs owner
- Index(es):
Relevant Pages
|
|
