Re: How to grant user to view SQLAgent Jobs Scheduler

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 09/25/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 25 Sep 2002 06:31:11 -0600

You wouldn't be able to set up something like this for
viewing job schedules and job histories through Enterprise
Manager. The user would need to own the jobs or be a
sysadmin and in either case, the user could change the jobs.
You would need to write a stored procedure that retrieves
the information and grant the appropriate permissions for
this.

-Sue

On Wed, 25 Sep 2002 16:07:39 +1000, david <""user\"@usr.com
- noreply Nospam> wrote:

>Hi,
>
>Any can assist on how to grant a user permission to view the SQLAgent
>Job Scheduler readonly. User should be able to view the jobs Scheduler,
>job history, but not be able to change/add anything.
>
>Any helps is much appreciated. We are using SQL Server 7
>
>Please post reply to news group.
>
>Regards
>David