Re: job security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 13:29:11 +0100

To 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
>
>

Relevant Pages

  • Re: Granting EXEC for read only SPs
    ... clearly understanding which stored procedures the user should have rights to ... problem is that the stored procedure is running under its own rights ... I created database role 'X' and granted EXEC permission for all SPs. ... the ones that modify data. ...
    (microsoft.public.sqlserver.security)
  • Re: execution permission on procedures
    ... A user only need exec permission on the stored procedure in order to execute that procedure and having that do ... Tibor Karaszi, SQL Server MVP ... "Panos" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedure and Table permissions
    ... execute permissions on the stored procedure. ... >given the user EXEC permission for the stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Stored Procedure and Table permissions
    ... the stored procedure reads specific data from a table - ... given the user EXEC permission for the stored procedure. ... Is there a way to configure permissions so that the user ... Bob Mooney ...
    (microsoft.public.sqlserver.security)