Re: user permission to run job only
From: SQL Apprentice (mssqlworld_at_yahoo.com)
Date: 01/18/05
- Next message: oj: "Re: Connection is busy with results for another hstmt"
- Previous message: oj: "Re: Help with an ADOCE SQL statement"
- In reply to: Aaron Weiker: "Re: user permission to run job only"
- Next in thread: oj: "Re: user permission to run job only"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 Jan 2005 15:47:31 -0800
Hi Aaron,
I was able to run the job after I assign the job owner to the user.
Thanks for all your help.
"Aaron Weiker" <aaron@sqlprogrammer.org> wrote in message
news:25211632415703029407012@news.microsoft.com...
> Hello SQL,
> What is the error message that you are getting? I didn't see one in any of
> your posts?
>
> --
> Aaron Weiker
> http://aaronweiker.com/
>
> > Aaron,
> >
> > I granted my user to "sp_startjob" and all other sp and xp in my job
> > steps. I keep getting this message even though I granted permission to
> > it already. sp_verify_job_identifiers
> >
> > What do you think?
> >
> > "Aaron Weiker" <aaron@sqlprogrammer.org> wrote in message
> > news:25121632415672535262384@news.microsoft.com...
> >
> >> Hello SQL,
> >> Have you tried just granting execute permission only to this
> >> procedure for
> >> the user?
> >> The following statement will great execute to that procedure when run
> >> from the MSDB database.
> >>
> >> GRANT EXECUTE ON dbo.sp_start_job TO <<user>>
> >>
> >> --
> >> Aaron Weiker
> >> http://aaronweiker.com/
> >>> Hi,
> >>>
> >>> Are there any server roles I can give to a user to run jobs only?
> >>>
> >>> OSQL -Smyserver -U? -P? -Q"EXEC msdb..sp_start_job @job_name =
> >>> 'dailyjob'" -oC:\jobresult.txt
> >>>
> >>> I want the user to run this job nightly by starting an OSQL.
> >>> However I don't know what user permission to give for running SQL
> >>> jobs only.
> >>>
> >>> Any suggestions?
> >>>
>
>
- Next message: oj: "Re: Connection is busy with results for another hstmt"
- Previous message: oj: "Re: Help with an ADOCE SQL statement"
- In reply to: Aaron Weiker: "Re: user permission to run job only"
- Next in thread: oj: "Re: user permission to run job only"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
