Monday, March 26, 2012

job security

I tried to search throughout BOL, but did not find any help on this:
who can start a job? what rights should the user have?
thanx
zarkoTo start a job a user needs permissions on the sp_startjob stored procedure
in msdb. By default the publice role has exec permission on that stored
procedure, so every user can start a job.
--
Jacco Schalkwijk
SQL Server MVP
"Zarko Jovanovic" <mind_less_NOSPAM_@.bigfoot.com> wrote in message
news:1097751700.805211@.internet.fina.hr...
>I tried to search throughout BOL, but did not find any help on this:
> who can start a job? what rights should the user have?
> thanx
> zarko
>|||You can find the permissions needed in books online under
sp_start_job. A user who is a sysadmin can start any job. A
non-sysadmin can start jobs that they own.
-Sue
On Thu, 14 Oct 2004 13:01:29 +0200, "Zarko Jovanovic"
<mind_less_NOSPAM_@.bigfoot.com> wrote:
>I tried to search throughout BOL, but did not find any help on this:
>who can start a job? what rights should the user have?
>thanx
>zarko
>sql

No comments:

Post a Comment