Monday, March 26, 2012

Scheduling a job under SA

I've shceduled a job under sa account (I've changed the password
though),this job access local folder of the box running SQL server.I have
added sa to the sysadmin role and it dose have access to the local folder
.How is it possible as *sa* is a sql server account and how it has the
enough permissions to access local file system?
Thanks a lotIf the job is owned by a sysadmin, it's operating under the
security context of the service account for SQL Agent.
-Sue
On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
wrote:

>I've shceduled a job under sa account (I've changed the password
>though),this job access local folder of the box running SQL server.I have
>added sa to the sysadmin role and it dose have access to the local folder
>.How is it possible as *sa* is a sql server account and how it has the
>enough permissions to access local file system?
>Thanks a lot
>|||Thanks a lot
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:e36gf11g82of53tigjia7dqobotkfvp5pt@.
4ax.com...
> If the job is owned by a sysadmin, it's operating under the
> security context of the service account for SQL Agent.
> -Sue
> On Mon, 8 Aug 2005 16:25:10 -0700, "J-T" <J-T@.nospam.com>
> wrote:
>
>

No comments:

Post a Comment