Permission to view only jobs

From: Manoj Gadhia (manoj.gadhia_at_upbna.com)
Date: 08/06/04 

Date: Fri, 6 Aug 2004 09:27:47 -0700

Hi

what are the permissions to be given for sql user if I
want him to see only jobs listed in the jobs section
under sql agent.

I tried giving ready only permissions on msdb & execute
permissions on sp_help_jobhistory. But still user cant
see the jobs listed.

Help will be appreciated.

Thanks,

Manoj

Relevant Pages

  • Re: 2005: databases attach as Read-Only
    ... In Security Tab add new user as sqlserver2005MSSQLUSER ... Give the Sql user all Permissions and full control ... in SQL Server Managment Studio right click on your database, ...
    (microsoft.public.sqlserver.setup)
  • Re: DTS FTP & Scheduling
    ... it's because when it's runnig as a scheduled job, it runs under that persons' permissions (that the SQL agent is running as) ... check these 2 thigns: ...
    (microsoft.public.sqlserver.dts)
  • Re: Export to Excel - File not created
    ... Does the network account that SQL Agent runs under have file create/delete ... Most good judgment comes from experience. ... however the Delete Excel file step and the Export to Excel step don't ... I thought maybe this was a permissions issue, ...
    (microsoft.public.sqlserver.dts)
  • Permissions view on application role
    ... How can I see the permissions for application role using stored procedure in ... the result for application role on which objects & what are the permissions? ... Manoj ...
    (microsoft.public.sqlserver.server)