job execution user change and ownership question

Hi

I am running my sql server 2000 server and agent as a service with domain
admin user.
Is this recommended?

Who should be the job owner?  sa or application user?
Can the job be run by any other user other than the user who started the
sqlserver agent.



TKS
Mangesh

Hi


"Mangesh Deshpande" < MangeshDeshpande@dis
cussions.microsoft.com> wrote in
message news:907D7E49-4B58-4D9F-B3D4- 149D45B9B94C@microso
ft.com...
> Hi
>
>  I am running my sql server 2000 server and agent as a service with domain
> admin user.
> Is this recommended?
No! A domain admin is over privileged, restrict the account to what you need
to do.

Check out the requirements for this account at
http://msdn.microsoft.com/library/d.../>
ew_6k1f.asp

You may also want to read some of the information on:
http://www.sqlsecurity.com/DesktopD...index=0&tabid=1

>
> Who should be the job owner?  sa or application user?

This will depend what the job does e.g  if you need to restrict the job to
the privleges of the application user or if the job needs higher
permissions.


> Can the job be run by any other user other than the user who started the
> sqlserver agent.
>
Yes, look at sp_start_job to run the job at a non-scheduled time. Check out
books online for information about the context in which jobs are run.

>
>
> TKS
> Mangesh

John